Symfony Profiler

SELECT
  `fishn_webp_media`.`id` as `fishn_webp_media.id`,
  `fishn_webp_media`.`media_id` as `fishn_webp_media.mediaId`,
  `fishn_webp_media`.`converted_media_id` as `fishn_webp_media.convertedMediaId`,
  `fishn_webp_media`.`status` as `fishn_webp_media.status`,
  `fishn_webp_media`.`created_at` as `fishn_webp_media.createdAt`,
  `fishn_webp_media`.`updated_at` as `fishn_webp_media.updatedAt`
FROM
  `fishn_webp_media`
WHERE
  (
    `fishn_webp_media`.`media_id` = ?
  )

SELECT `fishn_webp_media`.`id` as `fishn_webp_media.id`, `fishn_webp_media`.`media_id` as `fishn_webp_media.mediaId`, `fishn_webp_media`.`converted_media_id` as `fishn_webp_media.convertedMediaId`, `fishn_webp_media`.`status` as `fishn_webp_media.status`, `fishn_webp_media`.`created_at` as `fishn_webp_media.createdAt`, `fishn_webp_media`.`updated_at` as `fishn_webp_media.updatedAt` FROM `fishn_webp_media` WHERE (`fishn_webp_media`.`media_id` = 0xE2F640F0C5DA4372B1FE3992E9B6215E);

# 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/a22732ded4cf4a9699bdf718383c2e0c', '/navigation/dd1ba816880040fdac3bf9839b3409e2', '/navigation/de547c6d204c418fbd3e1fb25e37cec1', '/navigation/09a0ede5b6024a1188169a1698257db0', '/navigation/dcae9805bf87402c91ff65192f4c6d39', '/navigation/6041ac629ff74981aaa6aa1fdb80d1c7', '/navigation/3e3786427f3745668d85c1700d8f6dc4', '/navigation/210a507d02494830ac7f9cd0e44bce63', '/navigation/018bd791dbe47781bd06a26ef992eb03', '/navigation/5d8ad572dd24426c8f3b5abc340cf1e0', '/navigation/c70243cec476472a9f27ef41f6de1263', '/navigation/0ea2ef9abda6407db54ad6bd17321ae1', '/navigation/8ca5e5a13d854c26bc06316d448e2e33', '/navigation/9dd9a7be22084026b3c0c80748a2b650', '/navigation/018bd7bb7bd5747ba6b2123e107ba46a', '/navigation/d387b5437e08428081a4322725714c70', '/navigation/018bd7c74eee774c929fe063692f6438', '/navigation/018bd7c7c19e796a85772cc72155784c', '/navigation/018bd7c7ed727223b82addcd3d99a0a6', '/navigation/746ef7d056884b43b9ea715e2ccd1004', '/navigation/6983903fa8f447fabe478a5d036ccce8', '/navigation/97539461afc94a4ba2e94ecc02c50e91', '/navigation/93a64522c07f41e9940a48687d7a9de9', '/navigation/6e671e43c0ec44909a7532fcc60799d0', '/navigation/76f654081d49467688f1fee985033186', '/navigation/018bd82e162f7661ab6352322801dcfa', '/navigation/006a311f810f4a90a7d9edf3f3e04bdd', '/navigation/303e495ddda64b9f97109f8f7277cb01', '/navigation/2fea4e8dc478455c80e78a7c9a9549db', '/navigation/9df078f8c56c40be81590260a0e882d4', '/navigation/0f196697b9134f05aead0ee205778f3f', '/navigation/0931c7404d334a70a9b26e19b7ff1596', '/navigation/136fb1d824db4650ab869d00dc563b92', '/navigation/f496849e2e1b4a8a9182eb3b9e5b4955', '/navigation/7259223ac335478f9ea3ee94ed686171', '/navigation/c83982e05cb644e4aad72edb7a050149', '/navigation/130430dbc57445fe88d5c7b0d1562b19', '/navigation/3a02503acba54961982efcd0637849ca', '/navigation/9d359fd841a74f5d902f3fea0f7f267c', '/navigation/edcdb491bab148af98891db83d714d64', '/navigation/ba18c8c299cd4d6cbbb002cc638ae476', '/navigation/018deecdd9f47c679274a757e35582dc', '/navigation/d7396d7de88040e08752c05c50a42af0', '/navigation/018deb5bed6678d7bfab7d3c0c363929', '/navigation/80722507a8e04bf4adf8da352f09d9db', '/navigation/018deb6a88ea7ab6bfd60014c57e78eb', '/navigation/d310019432cf489a81a15c9e1b3fed12', '/navigation/7505bd05eb434a06a8e08f5ea45c8e22', '/navigation/57f6eea92ad2454199d66b3f373cd798', '/navigation/e17e79e0795d40198517b4b30f3c5958', '/navigation/9bcbce7f90e444889bf5793b1a1535bd', '/navigation/7db6a3a4fd174e8f96e92f3fea8af73a', '/navigation/ecb1ff13ef66444098ed6b1b393af6cb', '/navigation/638264e5676c4392b5d6ffb0cf0bbd8a', '/navigation/9158c41954fe4b1aa58028ea5bdf60c8', '/navigation/6ef3fd2f16c044eda561a923a4b0c5a4', '/navigation/83d4d1012f4443e8bca2d3c72324bd02', '/navigation/1272d660a184459cbd4f251d519c1434', '/navigation/275649d9330c4ab8b340197274ed1a17', '/navigation/f1617d75e5d04ce7b79057a11531e5d5', '/navigation/b9bc9f37ab0b4282b3184b084840fdc9', '/navigation/d77e7367ef464dc3bf2dea88916b924b', '/navigation/a7a530ae60a84acbbeab8b1bbd936add', '/navigation/e1bc84cfe0c24e16a48029293023f6d1', '/navigation/91d513b49de9404e9546bc56ff0108af', '/navigation/d57fbe09e19e4e57911fc72993a81be6', '/navigation/133439abeb2f4264b9caf030a12ec3c7', '/navigation/94a57d259fbf4fa48b61e7b06c40aafb', '/navigation/87341c2a85a34a339103d152f49662e9', '/navigation/15fe45c5d0f2453b96df8368d67e9931', '/navigation/976b49fac2ea4b83a8581f2b199d6e91', '/detail/269896df53174bc7acd92f6be1b8d7b9', '/navigation/1bf0d6251ac546aaa95723063f8aec23', '/navigation/e860a9f1b87e439db76f1f5672e5dcb5', '/navigation/a8051eaa592e4fa28286559bfdef221f', '/navigation/2842a9b5ab7a49589e0c9ce67095dadf', '/navigation/bc5142b6174c41778f8bfc5b5bff9d44', '/navigation/89acb45d240b4448951d2fdd8f27c069', '/navigation/153eaaec48aa4a22aab5ce4a4e032ce9', '/navigation/7c4f802d0e3b46f197ae3b7d804c2973', '/detail/018ec1db6eed73a3abbb360a8a985a15', '/detail/018ec1e138e573cfb106b39a38a9de18', '/detail/018ec1cb02f872dfa73fcbc845ee3aa9', '/navigation/2b0d8806038c47c3997225b405d890db', '/navigation/00b058bc4b9148c9b0c7c616f6c9b8d5', '/navigation/a4cc9589f6eb4d6e9a2b9e7a04344ca1', '/navigation/be432b5bef5540ab97646bf296dda98b', '/navigation/3a168a99437f4161bfb64f2d74bc59a1', '/navigation/b768cab78b6a4249b059f6402bb04ce6', '/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7', '/detail/70858eb69d604037869ebb6566e56203', '/navigation/88fda88a92bb415a81ecdb55cad77a19', '/navigation/6f33b8b26fc74ed0ad29de64da1f9cdf', '/navigation/06e0709e1ff542569f0ef0bf73748fd7', '/navigation/977b6fd0a4a444ec837febd2dec119a4', '/navigation/cc68f4e32abb4971a1aa983cd0fcff2f', '/navigation/21dd1fc46966402d8661fbda2cf5e0bc', '/navigation/c157e9398c3a4e47a4b5e93feb73b121', '/navigation/d1367ab402ca49e7837c3c50201d4cac', '/navigation/f3df76b7c84b47f798c77d2f913eed91', '/navigation/f3e9be797473451baed3e8465a86dedb', '/navigation/a3e75d8056de4f3f841aafa61044b6da', '/navigation/77700d219eab4e12bd754dd31bcd7c45', '/navigation/18c287a81016486db014a6b12f842d80', '/navigation/614e860d3d7a4cd3a302edd00ccc384f', '/navigation/9f765a78682e44f686358031d242dacb', '/navigation/aeb3081167ff43e3a7cad358b73934cc', '/navigation/05668311095d49f9959f90cad7a0cd4e', '/navigation/d240c1d282874be8a650c49e4430d019', '/navigation/a9514ed3727c4e238d52b367305efecb', '/navigation/ae92020fc70647f7a822e1a5ffc323cf', '/navigation/e7f381b818a74e97bcb62a770dbc0a3f', '/navigation/3885dbf3a63c4b1b84f85792fb8a4536', '/navigation/5aed49078d6f4a66be3c1c7b28f28ecc', '/navigation/e998fa5f026b467d86418f9a053dde3a', '/navigation/9bdb2d41fd05409380f2962a30a305ec', '/navigation/019fef3ea2034a02923ff6e29b9fd586', '/navigation/8b3d60ccfcb647d5a92992f7ce2ba69e', '/navigation/e5bd89229efa4fd8bdc40961e44af7c2', '/navigation/991eefe06ff64c17bf7d1200f5eff970', '/navigation/5e84685cc49b44ab9ac019c1d9aeea2b', '/navigation/193cff7fd2fc47838b7709396d9f7bf8', '/navigation/8919cfec1b134954a3b45e934861ba4f', '/navigation/54e57ca9300e4a1880421eea97d43da0', '/navigation/39012a41817f44af87d33cf4490d2b38', '/detail/bf8cead4a54a483ab78a1a05cd4abf8e', '/detail/6288945ff0ae41b0b77eb069fefb9ef1', '/detail/c6976234fc694a08ba0367d3642a8242', '/detail/ef41995ab478497dbf09901966e992c3', '/detail/7141bcfb323e4c72a7d6816d5cfbfa15', '/detail/1f2b39e0119d41ccb05e672c96b51d5b', '/detail/83ee9aeca40b4b7b8945ec33ee67e2b5', '/detail/af0e69fb093c4b6fae228b007e953086', '/detail/531b3ba50db14888b67d7b989fb6fa31', '/detail/4cd461730c484ecabebedcf79b907729', '/detail/a2b9add40b324286b320cd71eda7a857', '/detail/97e6c7b959ec497e9250ba9bc5a3ca4c', '/detail/c7a610c0a6d240c7b79f7d4298d548d0', '/detail/f5564f80f8bc488f99c21c3629a53c6e', '/detail/01f60eddc14a4a11b25b185b8899479c', '/detail/b8c79915c32b45bbb1ee587ff38d668e', '/detail/ee518b9760cd4ed687f517f937701904', '/detail/0ed08e396ed4478084784098f89bd9bf', '/detail/a16f148d779e4893b1c343ae4e51a4da', '/detail/2bd660d7f22a47909631505ae91031f9', '/detail/3fa1fcaa98d44341b51506408f2b804d', '/detail/fc933d37ab86454fa93ca0408fc4615f', '/detail/db61044059474b62a59cbb9fb41543af', '/detail/ae7448cf054d49a29b4c9902b46dda75', '/detail/4268a6f0cc3342e3b68b26b757b6df1b', '/detail/a4af88d79b1941e9a9a82ab40e0651dd', '/detail/845127339afc4863b892507076ac67ad', '/detail/ac71cd864da34083b11711a40b0eca34', '/detail/52a152840f0648d5ac342cd4003918bb', '/detail/acc0e33b2e184c3bbda1f1ea3742195f', '/detail/24f6353f2e90493bb2374841c4f64e48', '/detail/68f05e498bf64e1dbb230d80fe6a91ee', '/detail/96e7f0d3a3684bb59af7693a46a9cd15', '/detail/f9ceaf12aa7e4319b11de6d8517ee8cf', '/detail/ee79d59a47ac492bba3b1f700ae0cde7', '/detail/3b64f4d2fee54a20892064fd90530432', '/detail/a5ec4e95c0f14835a2dfb988e2cc7238', '/detail/7ca734cf5a344ac49faeb0b0e7a191af', '/detail/7f81db50cf864d99a91f9557c309b5f2', '/detail/389c47c352c34285a82aa0c0fc5935f8', '/detail/ce0d760368224e459768a3f167a33089', '/detail/108b3c8afbb04491b3eeb0f7ed8020f1', '/detail/dbd5d1912581449193c11a1155260b35', '/detail/7195737fe66544e7bd926ac9a6814075', '/detail/a6dae9ba97914c9aa4d2defdaad4b310', '/detail/812ec6b9a2c841448ade2ab723a416e3', '/detail/59e7622fd7794882a7fd8ed0645214a7', '/detail/31c32fd880e94f4d8bf4a0b0193a425e', '/detail/ca39b394f1d04b9088930afddde04953', '/detail/1621627f77d94075997a1f6bbd9a46df', '/detail/e7f5bfa5b50641958b4f73014c3b1c93', '/detail/067d4fb4a4d148c780759888b276402a', '/detail/2fe21209e07d446dbecff4f50e08c7d4', '/detail/3c936f6c9f3445cdba21916321d82587', '/detail/0c1413cf61ae426fb7e4f79e0655faef', '/detail/f6b7e631822747859fe6fcc2250dcff1', '/navigation/7641236cd7e545c19259015da0d7dafc', '/navigation/a016a87c446f4c9880f3f269f4ac16c1', '/navigation/64115a40330b4543b464cffdf12c345f', '/navigation/08b13d7084154c92b2eb2075b287307c', '/navigation/018cf811d9a9772484a6c381d3249b6c', '/navigation/1954e5bbe16a4d0dade155ad59ce4e01', '/navigation/d668890f1fca4488a358f0f4f7e6f931', '/navigation/018b615e1337726aa9da148cc7aa5fa4', '/navigation/018b61f0a9c674228b777f6b5eb4280a')) AND (seo_url.language_id = 0x4C0336B2410543DAB1CAF2364F3A7874) AND (seo_url.sales_channel_id = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# 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
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.translation.fallback_1.title`,
  `media.translation.title`,
  COALESCE(
    `media.translation.fallback_1.title`,
    `media.translation.title`, `media.translation.title`
  ) as `media.title`,
  `media.translation.fallback_1.alt`,
  `media.translation.alt`,
  COALESCE(
    `media.translation.fallback_1.alt`,
    `media.translation.alt`, `media.translation.alt`
  ) as `media.alt`,
  `media.translation.fallback_1.customFields`,
  `media.translation.customFields`,
  COALESCE(
    `media.translation.fallback_1.customFields`,
    `media.translation.customFields`,
    `media.translation.customFields`
  ) as `media.customFields`,
  `media.translation.fallback_1.createdAt`,
  `media.translation.createdAt`,
  `media.translation.fallback_1.updatedAt`,
  `media.translation.updatedAt`,
  `media.translation.fallback_1.mediaId`,
  `media.translation.mediaId`,
  `media.translation.fallback_1.languageId`,
  `media.translation.languageId`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.media_id,
      `media.translation`.title as `media.translation.title`,
      `media.translation`.alt as `media.translation.alt`,
      `media.translation`.custom_fields as `media.translation.customFields`,
      `media.translation`.created_at as `media.translation.createdAt`,
      `media.translation`.updated_at as `media.translation.updatedAt`,
      `media.translation`.media_id as `media.translation.mediaId`,
      `media.translation`.language_id as `media.translation.languageId`,
      `media.translation.fallback_1`.title as `media.translation.fallback_1.title`,
      `media.translation.fallback_1`.alt as `media.translation.fallback_1.alt`,
      `media.translation.fallback_1`.custom_fields as `media.translation.fallback_1.customFields`,
      `media.translation.fallback_1`.created_at as `media.translation.fallback_1.createdAt`,
      `media.translation.fallback_1`.updated_at as `media.translation.fallback_1.updatedAt`,
      `media.translation.fallback_1`.media_id as `media.translation.fallback_1.mediaId`,
      `media.translation.fallback_1`.language_id as `media.translation.fallback_1.languageId`
    FROM
      `media_translation` `media.translation`
      LEFT JOIN `media_translation` `media.translation.fallback_1` ON `media.translation`.`media_id` = `media.translation.fallback_1`.`media_id`
      AND `media.translation.fallback_1`.language_id = ?
    WHERE
      `media.translation`.language_id = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    `media`.`id` = ?
    AND (
      `media`.`private` = ?
      OR (
        `media`.`private` = ?
        AND `media.mediaFolder.defaultFolder`.`entity` = ?
      )
    )
  )

SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.fallback_1.title`, `media.translation.title`, COALESCE(`media.translation.fallback_1.title`,`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.fallback_1.alt`, `media.translation.alt`, COALESCE(`media.translation.fallback_1.alt`,`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.fallback_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.fallback_1.customFields`,`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.fallback_1.createdAt`, `media.translation.createdAt`, `media.translation.fallback_1.updatedAt`, `media.translation.updatedAt`, `media.translation.fallback_1.mediaId`, `media.translation.mediaId`, `media.translation.fallback_1.languageId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId`, `media.translation.fallback_1`.title as `media.translation.fallback_1.title`, `media.translation.fallback_1`.alt as `media.translation.fallback_1.alt`, `media.translation.fallback_1`.custom_fields as `media.translation.fallback_1.customFields`, `media.translation.fallback_1`.created_at as `media.translation.fallback_1.createdAt`, `media.translation.fallback_1`.updated_at as `media.translation.fallback_1.updatedAt`, `media.translation.fallback_1`.media_id as `media.translation.fallback_1.mediaId`, `media.translation.fallback_1`.language_id as `media.translation.fallback_1.languageId` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.fallback_1` ON `media.translation`.`media_id` = `media.translation.fallback_1`.`media_id` AND `media.translation.fallback_1`.language_id = 0x4C0336B2410543DAB1CAF2364F3A7874 WHERE `media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (`media`.`id` = 0x018B5E7CDDF772329D42A0822269C08A AND (`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')));

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
  AND (
    `product`.`id` IN (?, ?, ?)
  )
GROUP BY
  `product`.`id`

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) AND (`product`.`id` IN (0x0C1413CF61AE426FB7E4F79E0655FAEF, 0xFE07DBE8BF2449278F7AA0EC639B408C, 0xF6B7E631822747859FE6FCC2250DCFF1)) GROUP BY `product`.`id`;

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`
        ;

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
  AND (
    `product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
GROUP BY
  `product`.`id`

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) AND (`product`.`id` IN (0xEE79D59A47AC492BBA3B1F700AE0CDE7, 0x3B64F4D2FEE54A20892064FD90530432, 0xA5EC4E95C0F14835A2DFB988E2CC7238, 0x7CA734CF5A344AC49FAEB0B0E7A191AF, 0x9E293ACB5BC348629B142943E584FF6B, 0x7F81DB50CF864D99A91F9557C309B5F2, 0x389C47C352C34285A82AA0C0FC5935F8, 0xCE0D760368224E459768A3F167A33089, 0x108B3C8AFBB04491B3EEB0F7ED8020F1, 0xDBD5D1912581449193C11A1155260B35, 0xD897DB5F76B44B1F8CABE05E981A5CA8, 0x8C72D68713664D80BA8F11666C741D7B)) GROUP BY `product`.`id`;

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

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

# cart::promotion::search-ids
SELECT
  `promotion`.`id`
FROM
  `promotion`
  LEFT JOIN `acris_promotion_display` `promotion.acrisPromotionDisplay` ON `promotion`.`id` = `promotion.acrisPromotionDisplay`.`promotion_id`
  LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id`
WHERE
  (
    (
      `promotion`.`active` = ?
      AND `promotion.salesChannels`.`sales_channel_id` = ?
      AND (
        (
          `promotion`.`valid_from` <=> ?
          AND `promotion`.`valid_until` <=> ?
        )
        OR (
          `promotion`.`valid_from` <=> ?
          AND (`promotion`.`valid_until` > ?)
        )
        OR (
          (`promotion`.`valid_from` <= ?)
          AND `promotion`.`valid_until` <=> ?
        )
        OR (
          (`promotion`.`valid_from` <= ?)
          AND (`promotion`.`valid_until` > ?)
        )
      )
      AND `promotion`.`use_codes` = ?
    )
    AND NOT (
      `promotion.acrisPromotionDisplay`.`display_position` <=> ?
    )
  )
GROUP BY
  `promotion`.`id`
ORDER BY
  MAX(`promotion`.`priority`) DESC

# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `acris_promotion_display` `promotion.acrisPromotionDisplay` ON `promotion`.`id` = `promotion.acrisPromotionDisplay`.`promotion_id` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = 1 AND `promotion.salesChannels`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2025-04-19 23:26:10')) OR ((`promotion`.`valid_from` <= '2025-04-19 23:26:10') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2025-04-19 23:26:10') AND (`promotion`.`valid_until` > '2025-04-19 23:26:10'))) AND `promotion`.`use_codes` = 0) AND NOT (`promotion.acrisPromotionDisplay`.`display_position` <=> 'onlyCart')) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;