Symfony Profiler

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/navigation/4d69666120394f6da16b654d61787573', '/navigation/946f7812524c4e33ab91e40a519eee46', '/navigation/e110a8473d7a4ee2a4cc13695eaad168', '/navigation/b4a0f1e73bea419bb5d86f266c224c07', '/navigation/018c68105b50776a9e4d7f859687cd03', '/navigation/0190027169677386b1d5ec73f49d2975', '/navigation/3032313631304338a637313832613163', '/navigation/3732323239384233b034643330353437', '/navigation/6231303462644364b833616333373037', '/navigation/3030383132384236b331623837376134', '/navigation/3061373038354266a334313463386131', '/navigation/3132646163614132b661636666343765', '/navigation/3138626531304338b164656465356431', '/navigation/3239326635354337a161313134346638', '/navigation/3331396233364564b163393762356663', '/navigation/3365313261644463a433363733383066', '/navigation/3432663237324531b635306561613138', '/navigation/3437653333384063a534613961326365', '/navigation/3633383462364136a661326530326232', '/navigation/6134396134334734b238336437333032', '/navigation/6230633064624731a266316635333938', '/navigation/6332346131384565b934376562343339', '/navigation/6434653732364461b863333934623835', '/navigation/6531306362324134b662383039663136', '/navigation/6638306438364532a533323136663562', '/navigation/6d616b65416c4661a05200006f6d656f', '/navigation/6263323665614435b339646137346662', '/navigation/6d616b65416c4661a0526f6d656f5f6d', '/navigation/6d616b65417544698000000000000000', '/navigation/3030343164364265b831306262333762', '/navigation/3031636364634465a230323466323464', '/navigation/3034646436634765a333663231383762', '/navigation/3037363333374932a365303833613133', '/navigation/3039366131384937b664623564636136', '/navigation/3064616634634165a439303134363533', '/navigation/3131383337364761a531323638623261', '/navigation/3132373566324662a233636562646335', '/navigation/3136366334334139a639366639343465', '/navigation/3162613137344537b031356235376437', '/navigation/3330626135634139a366386538316131', '/navigation/3331643233314865a130353933613237', '/navigation/3430393331334139b664323839306664', '/navigation/3433383830384765a636666335653261', '/navigation/3433393266314761b638376563666562', '/navigation/3466396330324232a137653235303134', '/navigation/3532303237374233a464626532336366', '/navigation/3536666665664531a366653338623762', '/navigation/3537666466344938b736363366306238', '/navigation/3539646534624431b433353839313164', '/navigation/3561636130654239a361666564393564', '/navigation/3564636366374834a134646532663464', '/navigation/3565323265304634b065636338306430', '/navigation/3566643431644338a563666236666465', '/navigation/3633373532614334b732643232653035', '/navigation/3636353564394066b933653934613631', '/navigation/3639333339654366b632353831393937', '/navigation/3733303133654366b638393637643266', '/navigation/3737616339354664a338633735333030', '/navigation/3762323937364039a666663766363832', '/navigation/3930393461344239a366623265653033', '/navigation/3931396430664735a631333264626333', '/navigation/3962396137314730b665393936616238', '/navigation/41315f6d616b4541b564000000000069', '/navigation/41335f6d616b4541b564000000000069', '/navigation/41345f6d616b4541b564000000000069', '/navigation/41365f6d616b4541b564000000000069', '/navigation/41385f6d616b4541b564000000000069', '/navigation/51325f6d616b4541b564000000000069', '/navigation/51335f6d616b4541b564000000000069', '/navigation/51345f6d616b4541b564000000000069', '/navigation/51355f6d616b4541b564000000000069', '/navigation/51365f6d616b4541b564000000000069', '/navigation/51375f6d616b4541b564000000000069', '/navigation/51385f6d616b4541b564000000000069', '/navigation/5155415454524f5fad616b6541756469', '/navigation/52385f6d616b4541b564000000000069', '/navigation/525320335f6d416ba541000000756469', '/navigation/52532051335f4d61ab65000041756469', '/navigation/52532051385f4d61ab65000041756469', '/navigation/53335f6d616b4541b564000000000069', '/navigation/53355f6d616b4541b564000000000069', '/navigation/53365f6d616b4541b564000000000069', '/navigation/53385f6d616b4541b564000000000069', '/navigation/5351325f6d614b658175000000006469', '/navigation/5351355f6d614b658175000000006469', '/navigation/5351375f6d614b658175000000006469', '/navigation/5351385f6d614b658175000000006469', '/navigation/54542052535f4d61ab65000041756469', '/navigation/54545f6d616b4541b564000000000069', '/navigation/6131613936624863a262326265313138', '/navigation/6138363933354934b639386535306436', '/navigation/6139613033314437b638303938353963', '/navigation/6164346432394830b966353166326632', '/navigation/6231313833344163b363303461613133', '/navigation/6232353234334061b838383936303766', '/navigation/6237623864344064b230393937386265', '/navigation/6262383330644438a630396431636665', '/navigation/6264666535374464b135303736373265', '/navigation/6332333064374335b439383636623761', '/navigation/6335313666364331b362303834373833', '/navigation/6336653861364666b735363962656536', '/navigation/6364313561644233b639366363616334', '/navigation/6366643139304131b462343066333230', '/navigation/6432636434364161b766643730373739', '/navigation/6462646531394036a637323938323463', '/navigation/652d74726f6e4f6da16b006541756469', '/navigation/6536343965614634b932616633643936', '/navigation/6537386530314964b864633863316537', '/navigation/6537616564324536b238313635653562', '/navigation/6565313861344439b934353335333266', '/navigation/6664306536304966b061623139663337', '/navigation/6664323430624766a561313238313635', '/navigation/6d616b65417544699f6d6f64656c4131', '/navigation/6d616b65417544699f6d6f64656c4133', '/navigation/6d616b65417544699f6d6f64656c4134', '/navigation/6d616b65417544699f6d6f64656c4135', '/navigation/6d616b65417544699f6d6f64656c4136', '/navigation/6d616b65417544699f6d6f64656c4137', '/navigation/6d616b65417544699f6d6f64656c4138', '/navigation/6d616b65417544699f6d6f64656c5132', '/navigation/6d616b65417544699f6d6f64656c5133', '/navigation/6d616b65417544699f6d6f64656c5134', '/navigation/6d616b65417544699f6d6f64656c5135', '/navigation/6d616b65417544699f6d6f64656c5137', '/navigation/6d616b65417544699f6d6f64656c5138', '/navigation/6d616b65417544699f6d6f64656c5253', '/navigation/6d616b65417544699f6d6f64656c5333', '/navigation/6d616b65417544699f6d6f64656c5334', '/navigation/6d616b65417544699f6d6f64656c5335', '/navigation/6d616b65417544699f6d6f64656c5336', '/navigation/6d616b65417544699f6d6f64656c5337', '/navigation/6d616b65417544699f6d6f64656c5351', '/navigation/6d616b65417544699f6d6f64656c5454', '/navigation/6d616b65417544699f6d6f64656c652d', '/navigation/6d616b65424d40578000000000000000', '/navigation/3131365f6d614b65824d000000000057', '/navigation/3131385f6d614b65824d000000000057', '/navigation/3232305f6d614b65824d000000000057', '/navigation/3331385f6d614b65824d000000000057', '/navigation/3533383037664735b564613236313234', '/navigation/58315f6d616b45428d57000000000000', '/navigation/58325f6d616b45428d57000000000000', '/navigation/5a345f6d616b45428d57000000000000', '/navigation/6d616b65424d475fad6f0064656c5831', '/navigation/6d616b65424d475fad6f64656c313136', '/navigation/6d616b65424d475fad6f64656c313138', '/navigation/6d616b65424d475fad6f64656c343230', '/navigation/6d616b6542c34c72b3740000006e6572', '/navigation/6d616b6543614274a86100000000676f', '/navigation/3037383636384663b030356533306131', '/navigation/6d616b6543614274a861676f5f6d6f64', '/navigation/6d616b6543694472afc300000000ab6e', '/navigation/6462366532624465a234626661363631', '/navigation/6d616b6543694472afc3ab6e5f6d6f64', '/navigation/6d616b6543754072a100000000000000', '/navigation/3536303635334430b737313564633662', '/navigation/3731323336614031a665643435343563', '/navigation/41746563615f4d61ab65004375707261', '/navigation/426f726e5f6d416ba543000075707261', '/navigation/4c656f6e5f6d416ba543000075707261', '/navigation/6d616b6543754072a15f6d6f64656c41', '/navigation/6d616b6543754072a15f6d6f64656c42', '/navigation/6d616b6543754072a15f6d6f64656c46', '/navigation/6d616b6543754072a15f6d6f64656c4c', '/navigation/6d616b6544614369a100000000000000', '/navigation/4475737465724f6da16b654461636961', '/navigation/537072696e674f6da16b654461636961', '/navigation/6365336431344037b636306662643262', '/navigation/6d616b6544754361b469000000000000', '/navigation/3030663637384166b564623533646366', '/navigation/3039616363644862a238653066643338', '/navigation/3039633262624662a537333630626462', '/navigation/3231363537634439a563326232633030', '/navigation/3233363663624136b631643463356535', '/navigation/3235373238304430b837643864383466', '/navigation/3238653961354565b537623866303732', '/navigation/3330353661614964b164623732396638', '/navigation/3365626266614238b965666337633835', '/navigation/3530633830344666b865636136346664', '/navigation/3537616530614833a330633664623132', '/navigation/3565333133644830a333346162633766', '/navigation/3662393730644334b666643335646433', '/navigation/3762653635334263b136386534383333', '/navigation/3833616661334633a161653361326365', '/navigation/3864333331374434a364616333386438', '/navigation/3935633033614263b939396633613132', '/navigation/3962643733364138b133346561396365', '/navigation/6161353233324632a262326139623436', '/navigation/6162613033644365a438663063356538', '/navigation/6232303734354866b864646136666262', '/navigation/6333336339614437b563373037366235', '/navigation/6338343331314064b165353633326630', '/navigation/6539346532394535a535363130313032', '/navigation/6563663638354030b239626635616331', '/navigation/6566643530314234b162393461346436', '/navigation/6633323438334362a366326439653164', '/navigation/6662643138654063b463616132363735', '/navigation/6d616b65466941748000000000000000', '/navigation/3132345f6d614b658669000000006174', '/navigation/3530305f6d614b658669000000006174', '/navigation/3630305f6d614b658669000000006174', '/navigation/6d616b65466941749f6d6f64656c3132', '/navigation/6d616b65466941749f6d6f64656c3530', '/navigation/6d616b65466f42648000000000000000', '/navigation/3037333464334563b432633265353533', '/navigation/3831363564654037a331313666366138', '/navigation/422d4d61785f4d61ab650000466f7264', '/navigation/432d4d61785f4d61ab650000466f7264', '/navigation/456467655f6d416ba5460000006f7264', '/navigation/4669657374614f6da16b0065466f7264', '/navigation/466f6375735f4d61ab650000466f7264', '/navigation/4b7567615f6d416ba5460000006f7264', '/navigation/52616e6765724f6da16b0065466f7264', '/navigation/5472616e7369445fad616b65466f7264', '/navigation/6330666137664539b830323764333463', '/navigation/6d616b65466f42649f6d6f64656c4564', '/navigation/6d616b65466f42649f6d6f64656c4669', '/navigation/6d616b65486f4e64a100000000000000', '/navigation/6d616b654879456ea461000000000069', '/navigation/3136303661384163a365636139346364', '/navigation/3264366531634534b636646261343863', '/navigation/4b6f6e615f6d416ba54879756e646169', '/navigation/6631363930654066a265333539363965', '/navigation/6639346130614234b531646432333862', '/navigation/6932305f6d614b65887900756e646169', '/navigation/6933305f6d614b65887900756e646169', '/navigation/6d616b654879456ea461695f6d6f6465', '/navigation/6d616b654a614775a172000000000000', '/navigation/6365356238374263b136396566343763', '/navigation/6434393030614461a363616531353837', '/navigation/6d616b654a614775a1725f6d6f64656c', '/navigation/6d616b654a6545708000000000000000', '/navigation/436f6d706173435fad616b654a656570', '/navigation/6d616b654a6545709f6d6f64656c436f', '/navigation/6d616b654a6545709f6d6f64656c5772', '/navigation/6d616b654b54404d8000000000000000', '/navigation/3335383232614537a661363865343430', '/navigation/6d616b654b544d5fad6f64656c313239', '/navigation/6d616b654b614761b361000000006b69', '/navigation/6d616b654b6940618000000000000000', '/navigation/4556365f6d614b658b69000000000061', '/navigation/4556395f6d614b658b69000000000061', '/navigation/4e69726f5f6d416ba54b000000006961', '/navigation/506963616e744f5fad61006b654b6961', '/navigation/52696f5f6d614b658b69000000000061', '/navigation/536f72656e744f5fad61006b654b6961', '/navigation/536f756c5f6d416ba54b000000006961', '/navigation/53706f72746147659f6d616b654b6961', '/navigation/5374696e6765425fad61006b654b6961', '/navigation/53746f6e69634f6da16b0000654b6961', '/navigation/56656e67615f4d61ab650000004b6961', '/navigation/58436565645f4d61ab650000004b6961', '/navigation/6361373131644665b764333733363939', '/navigation/63656527645f4d61ab650000004b6961', '/navigation/6430653831614530b730363736636438', '/navigation/6d616b654b69415fad6f64656c4e6972', '/navigation/6d616b654b69415fad6f64656c52696f', '/navigation/6d616b654b69415fad6f64656c536f72', '/navigation/6d616b654b69415fad6f64656c53706f', '/navigation/6d616b654b69415fad6f64656c537469', '/navigation/6d616b654b69415fad6f64656c53746f', '/navigation/6d616b654b69415fad6f64656c584365', '/navigation/6d616b654b69415fad6f64656c636565', '/navigation/6d616b654b69415fad6f64656c70726f', '/navigation/6d616b654b6e4175b300000000000000', '/navigation/536b7920695f4d61ab65004b6e617573', '/navigation/6d616b654c4d40438000000000000000', '/navigation/6d616b654c614e64a05200006f766572', '/navigation/6536613365324236a532323839323539', '/navigation/6d616b654c654875b300000000000000', '/navigation/55585f6d616b454ca578000000007573', '/navigation/6d616b654d41404e8000000000000000', '/navigation/6d616b654d614875b300000000000000', '/navigation/3066323364314231b632353362333961', '/navigation/3238623065644237b262383335373066', '/navigation/3665383631384639a637616465663630', '/navigation/3665646261384934b033353965613630', '/navigation/3763393662314238b265663365386236', '/navigation/4d49464120394f6da16b654d61787573', '/navigation/5439305f6d614b658d61000000787573', '/navigation/6132626561384630b465623535646537', '/navigation/6236393935664364a432306432386637', '/navigation/6563346138654830b830626535353237', '/navigation/6d616b654d614a64a100000000000000', '/navigation/325f6d616b654d61ba64000000000061', '/navigation/43582d33305f4d61ab65004d617a6461', '/navigation/43582d335f6d416ba54d0000617a6461', '/navigation/4d582d355f6d416ba54d0000617a6461', '/navigation/6d616b654d614a64a15f6d6f64656c4d', '/navigation/6d616b654d654263a56465732d42656e', '/navigation/6d616b654d694473b562000069736869', '/navigation/3565313864324361a634633339663263', '/navigation/6631333864374437a633616630333033', '/navigation/6d616b654d694e69a0280000424d5729', '/navigation/3335306164394165b465666565613261', '/navigation/3733663039364161b434643134616634', '/navigation/3839326636384139a637376165316330', '/navigation/3866303836654732b533343761616638', '/navigation/6230326536354366b266346631623733', '/navigation/6531643830364437b263366562373933', '/navigation/6d616b654d694e69a028424d57295f6d', '/navigation/6d616b654d6f446fa0470000757a7a69', '/navigation/6d616b654e694373a16e000000000000', '/navigation/3331373530314964a363323038646634', '/navigation/3633356538324737b564663837396232', '/navigation/4c6561665f6d416ba54e00697373616e', '/navigation/6234353235324962b264363135653264', '/navigation/6d616b654f70456c8000000000000000', '/navigation/3162333639664437b136383864633331', '/navigation/3166633738364661a633383463396333', '/navigation/3335613163664361b363633732343362', '/navigation/41737472615f4d61ab6500004f70656c', '/navigation/436f6d626f5f4d61ab6500004f70656c', '/navigation/436f7273615f4d61ab6500004f70656c', '/navigation/4d6f6b6b6120485fad616b654f70656c', '/navigation/4d6f6b6b615f4d61ab6500004f70656c', '/navigation/5a61666972614f6da16b00654f70656c', '/navigation/6d616b654f70456c9f6d6f64656c4173', '/navigation/6d616b654f70456c9f6d6f64656c436f', '/navigation/6d616b654f70456c9f6d6f64656c5a61', '/navigation/6d616b654f72416ea765000063616d70', '/navigation/6d616b6550654567a56f000000000074', '/navigation/3130385f6d614b659065007567656f74', '/navigation/333030385f6d416ba550657567656f74', '/navigation/6d616b65506f4273a368000000000065', '/navigation/3337623536634531a563383265373533', '/navigation/3435383366624561a238393663393937', '/navigation/3663303738364662b933623466653234', '/navigation/3931315f6d614b65906f007273636865', '/navigation/3931345f6d614b65906f007273636865', '/navigation/3932385f6d614b65906f007273636865', '/navigation/6d616b65506f4273a368655f6d6f6465', '/navigation/6d616b6552654e61b56c000000000074', '/navigation/3466396339374261b866663862366365', '/navigation/436c696f5f6d416ba552656e61756c74', '/navigation/6336623731304763b330313936306633', '/navigation/6436366135344264a332613062343862', '/navigation/6461303266384561a139303065613334', '/navigation/6d616b6552654e61b56c745f6d6f6465', '/navigation/6d616b65536541748000000000000000', '/navigation/3931303364334735a164653031616230', '/navigation/41726f6e615f4d61ab65000053656174', '/navigation/41746563615f4d61ab65000053656174', '/navigation/4962697a615f4d61ab65000053656174', '/navigation/4c656f6e5f6d416ba553000000656174', '/navigation/4d69695f6d614b659365000000006174', '/navigation/4dc3935f6d614b659365000000006174', '/navigation/5461727261634f5fad616b6553656174', '/navigation/6d616b65536541749f6d6f64656c4172', '/navigation/6d616b65536541749f6d6f64656c4174', '/navigation/6d616b65536541749f6d6f64656c4962', '/navigation/6d616b65536541749f6d6f64656c4c65', '/navigation/6d616b65536541749f6d6f64656c4d69', '/navigation/6d616b65536541749f6d6f64656c4dc3', '/navigation/6d616b65536541749f6d6f64656c5461', '/navigation/6d616b65536d4172b400000000000000', '/navigation/6536626465334231b461333835373637', '/navigation/6d616b6553754a75ab69000000000000', '/navigation/49676e69735f4d61ab6553757a756b69', '/navigation/53776966745f4d61ab6553757a756b69', '/navigation/6d616b6553754e6ca967000000006874', '/navigation/3731626164614465b436343432643435', '/navigation/6d616b655465436ca100000000000000', '/navigation/6338646264334765b163613030633365', '/navigation/6d616b65546f496fb461000000000000', '/navigation/3938343163344434a638386230623466', '/navigation/6d616b65546f496fb4615f6d6f64656c', '/navigation/6d616b65566f4c6bb37700006167656e', '/navigation/3031613661664466b261316331646135', '/navigation/3061353561384563b064306562313139', '/navigation/3061646661364061b438383530326463', '/navigation/3130303832654330a561343534653433', '/navigation/3137636238374136b932623031373030', '/navigation/3139646539614263b237376465346430', '/navigation/3164376162354863b234383131393837', '/navigation/3166373337654261a466633763633831', '/navigation/3233616237354262a230343732393163', '/navigation/3261653139374561b736323863666665', '/navigation/3262616137314630a362613939653936', '/navigation/3335353064384637b762333266343062', '/navigation/3336383437624264b365356230313737', '/navigation/3337313930654766a439333362666639', '/navigation/3366323863624630b464393932343761', '/navigation/3437396564394332b737306630623563', '/navigation/3532633430634233a639343334333935', '/navigation/3565363435644436b531613132653232', '/navigation/3635316438614036a138396265663762', '/navigation/3661393438624635b139646536366462', '/navigation/3663353639644163a438356663326666', '/navigation/3733306438624963b964376561666437', '/navigation/3737323635614663b034343838333731', '/navigation/3737663930324735a232386632623362', '/navigation/3738343131624963b037323634656432', '/navigation/3739643666314138b135373939613865', '/navigation/3763313562334665b739663638333265', '/navigation/3837663063654532b438633635333731', '/navigation/3866323961364062a432353739313635', '/navigation/3936366666394939b339626336386166', '/navigation/3961313166364133b330623433396637', '/navigation/3962303931644733a533313634623966', '/navigation/3966353833334737a539343861616232', '/navigation/3966613163654436b739353635353031', '/navigation/6132343231664566b665383164333138', '/navigation/6134396261664638b263326238356634', '/navigation/6135336237654666b331653665663539', '/navigation/6138323631354266b063653737653337', '/navigation/6165623930344536a330613565633131', '/navigation/6230396533614765b636346335646366', '/navigation/6262306332364235b332643934613465', '/navigation/6262626239614036a438653731613536', '/navigation/6330323063364766b163383563376431', '/navigation/6335313064334432b737383035636632', '/navigation/6336386365654636b066356332643262', '/navigation/6363653234324334b164643934333031', '/navigation/6365333137624435a664386464333263', '/navigation/6366373264334666b738303162353465', '/navigation/6461383937654532a536613265313366', '/navigation/6462303632344764a235646262303561', '/navigation/6463656661314230a333633537343236', '/navigation/6465663835314234b837316236656339', '/navigation/6534663038364539b264636131323630', '/navigation/6562323165614534a532323333393365', '/navigation/6630333337354230b062626362363461', '/navigation/6633623833334965b430383435393737', '/navigation/6635373630654630b665626632313438', '/navigation/6637653633324336b134383938316532', '/navigation/6639373035344931b061633735643366', '/navigation/6662336139664537a266623531653162', '/navigation/6665633833364532b830343939323737', '/navigation/6d616b65566f4c6bb3776167656e5f6d', '/navigation/6d616b65566f4c76af00000000000000', '/navigation/584334305f6d416ba55600006f6c766f', '/navigation/6d616b655765496eb362000000657267', '/navigation/3838343731644466a261363433626365', '/navigation/6d616b65616e4465b265000000000000', '/navigation/6262386164354239b764663332656564', '/navigation/6d616b65616e4465b2655f6d6f64656c', '/navigation/6d616b65c5a04b6fa461000000000000', '/navigation/3137663034624365b763363762343235', '/navigation/3534313836634530b663383834383263', '/navigation/3631343231634530a539333338333235', '/navigation/456e7961715f4d61ab65c5a06b6f6461', '/navigation/46616269615f4d61ab65c5a06b6f6461', '/navigation/4b616d69715f4d61ab65c5a06b6f6461', '/navigation/4b61726f715f4d61ab65c5a06b6f6461', '/navigation/5363616c615f4d61ab65c5a06b6f6461', '/navigation/596574695f6d416ba5c500a06b6f6461', '/navigation/6133656262384039a461333839363731', '/navigation/6561386666334335b062656630326461', '/navigation/6d616b65c5a04b6fa4615f6d6f64656c', '/navigation/de22886689134afcad0ed7fdf5c85a80', '/navigation/5b5d9249f71444f29a0c16f529931b8e', '/navigation/aff1c44b4386420c983ee8d4459c81d9', '/navigation/3a6a4c21edea493ab01463025c907ee5', '/navigation/4edb372ddb1c4cefb23c16c5c12c9269', '/navigation/019002d711577968a4a5fcf7d277759a', '/navigation/019002d75a6e7397ac061319c5c5f933', '/navigation/0190255fa4947dee895f0235a16fa0d9', '/navigation/0190255fe83b7536af83cf6ea9406443')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xDF2AA8DB6F474BB3A44EAEEA4C4BB851 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# header::navigation::read
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.media`.`id` as `category.media.id`,
  `category.media`.`user_id` as `category.media.userId`,
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`,
  `category.media`.`mime_type` as `category.media.mimeType`,
  `category.media`.`file_extension` as `category.media.fileExtension`,
  `category.media`.`uploaded_at` as `category.media.uploadedAt`,
  `category.media`.`file_name` as `category.media.fileName`,
  `category.media`.`file_size` as `category.media.fileSize`,
  `category.media`.`media_type` as `category.media.mediaTypeRaw`,
  `category.media`.`meta_data` as `category.media.metaData`,
  `category.media`.`config` as `category.media.config`,
  `category.media`.`path` as `category.media.path`,
  `category.media`.`private` as `category.media.private`,
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`,
  `category.media`.`created_at` as `category.media.createdAt`,
  `category.media`.`updated_at` as `category.media.updatedAt`,
  `category.media.translation.title`,
  COALESCE(
    `category.media.translation.title`,
    `category.media.translation.title`
  ) as `category.media.title`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.alt`,
    `category.media.translation.alt`
  ) as `category.media.alt`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.customFields`,
    `category.media.translation.customFields`
  ) as `category.media.customFields`,
  `category.media.translation.createdAt`,
  `category.media.translation.updatedAt`,
  `category.media.translation.mediaId`,
  `category.media.translation.languageId`,
  `category.translation.name`,
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) as `category.name`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.description`,
  COALESCE(
    `category.translation.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`,
  `category.translation.createdAt`,
  `category.translation.updatedAt`,
  `category.translation.categoryId`,
  `category.translation.languageId`,
  `category.translation.categoryVersionId`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.category_id,
      `category.translation`.category_version_id,
      `category.translation`.name as `category.translation.name`,
      `category.translation`.breadcrumb as `category.translation.breadcrumb`,
      `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`,
      `category.translation`.custom_fields as `category.translation.customFields`,
      `category.translation`.created_at as `category.translation.createdAt`,
      `category.translation`.updated_at as `category.translation.updatedAt`,
      `category.translation`.category_id as `category.translation.categoryId`,
      `category.translation`.language_id as `category.translation.languageId`,
      `category.translation`.category_version_id as `category.translation.categoryVersionId`
    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
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.media_id,
      `category.media.translation`.title as `category.media.translation.title`,
      `category.media.translation`.alt as `category.media.translation.alt`,
      `category.media.translation`.custom_fields as `category.media.translation.customFields`,
      `category.media.translation`.created_at as `category.media.translation.createdAt`,
      `category.media.translation`.updated_at as `category.media.translation.updatedAt`,
      `category.media.translation`.media_id as `category.media.translation.mediaId`,
      `category.media.translation`.language_id as `category.media.translation.languageId`
    FROM
      `media_translation` `category.media.translation`
    WHERE
      `category.media.translation`.language_id = ?
  ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category`.`path` LIKE ?
      AND (
        `category`.`level` > ?
        AND `category`.`level` <= ?
      )
    )
  )

# header::navigation::read
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.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `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`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` 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 LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|a7da61aabbde4d178077997c6932d136|%' AND (`category`.`level` > 1 AND `category`.`level` <= 4)));

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`,
  `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`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  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`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  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`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` 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`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` 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` WHERE (`app`.`active` = 1);

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;