Symfony Profiler

Query Metrics

44 Database Queries
26 Different statements
19.60 ms Query time
Queries


# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
SELECT `key`, `value` FROM `app_config`
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
SELECT seo_path_info as seoPathInfo, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info LIKE CONCAT(TRIM(TRAILING "/" FROM ?), "%")) ORDER BY sales_channel_id IS NULL ASC, LENGTH(seoPathInfo) ASC, is_canonical DESC LIMIT 1
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, ? REGEXP `old_url_regex` as regex0, ? REGEXP `old_url_regex` as regex2, ? REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ?) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ?))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex`)))) LIMIT 6;
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_fb_form` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-01-19T17:02:08+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2025-01-19T17:02:08+00:00')) AND `active` = '1';
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_fb_element` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2025-01-19T17:02:08+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2025-01-19T17:02:08+00:00')) AND `active` = '1';
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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 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 `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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`.`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`, 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`.`id` IN (?)
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
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 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 `moorl_fb_form`.`id` as `moorl_fb_form.id`, `moorl_fb_form`.`tax_id` as `moorl_fb_form.taxId`, `moorl_fb_form`.`user_id` as `moorl_fb_form.userId`, `moorl_fb_form`.`media_id` as `moorl_fb_form.mediaId`, `moorl_fb_form`.`sales_channel_id` as `moorl_fb_form.salesChannelId`, `moorl_fb_form`.`product_stream_id` as `moorl_fb_form.productStreamId`, `moorl_fb_form`.`customer_group_id` as `moorl_fb_form.customerGroupId`, `moorl_fb_form`.`shipping_method_id` as `moorl_fb_form.shippingMethodId`, `moorl_fb_form`.`payment_method_id` as `moorl_fb_form.paymentMethodId`, `moorl_fb_form`.`country_id` as `moorl_fb_form.countryId`, `moorl_fb_form`.`language_id` as `moorl_fb_form.languageId`, `moorl_fb_form`.`show_from` as `moorl_fb_form.showFrom`, `moorl_fb_form`.`show_until` as `moorl_fb_form.showUntil`, `moorl_fb_form`.`media_folder_id` as `moorl_fb_form.mediaFolderId`, `moorl_fb_form`.`type` as `moorl_fb_form.type`, `moorl_fb_form`.`active` as `moorl_fb_form.active`, `moorl_fb_form`.`use_captcha` as `moorl_fb_form.useCaptcha`, `moorl_fb_form`.`send_mail` as `moorl_fb_form.sendMail`, `moorl_fb_form`.`insert_database` as `moorl_fb_form.insertDatabase`, `moorl_fb_form`.`locked` as `moorl_fb_form.locked`, `moorl_fb_form`.`technical_name` as `moorl_fb_form.technicalName`, `moorl_fb_form`.`redirect_to` as `moorl_fb_form.redirectTo`, `moorl_fb_form`.`related_entity` as `moorl_fb_form.relatedEntity`, `moorl_fb_form`.`send_copy_type` as `moorl_fb_form.sendCopyType`, `moorl_fb_form`.`config` as `moorl_fb_form.config`, `moorl_fb_form`.`actions` as `moorl_fb_form.actions`, `moorl_fb_form`.`custom_fields` as `moorl_fb_form.customFields`, `moorl_fb_form.tax`.`id` as `moorl_fb_form.tax.id`, `moorl_fb_form.tax`.`tax_rate` as `moorl_fb_form.tax.taxRate`, `moorl_fb_form.tax`.`name` as `moorl_fb_form.tax.name`, `moorl_fb_form.tax`.`position` as `moorl_fb_form.tax.position`, `moorl_fb_form.tax`.`custom_fields` as `moorl_fb_form.tax.customFields`, `moorl_fb_form.tax`.`created_at` as `moorl_fb_form.tax.createdAt`, `moorl_fb_form.tax`.`updated_at` as `moorl_fb_form.tax.updatedAt`, `moorl_fb_form.media`.`id` as `moorl_fb_form.media.id`, `moorl_fb_form.media`.`user_id` as `moorl_fb_form.media.userId`, `moorl_fb_form.media`.`media_folder_id` as `moorl_fb_form.media.mediaFolderId`, `moorl_fb_form.media`.`mime_type` as `moorl_fb_form.media.mimeType`, `moorl_fb_form.media`.`file_extension` as `moorl_fb_form.media.fileExtension`, `moorl_fb_form.media`.`uploaded_at` as `moorl_fb_form.media.uploadedAt`, `moorl_fb_form.media`.`file_name` as `moorl_fb_form.media.fileName`, `moorl_fb_form.media`.`file_size` as `moorl_fb_form.media.fileSize`, `moorl_fb_form.media`.`media_type` as `moorl_fb_form.media.mediaTypeRaw`, `moorl_fb_form.media`.`meta_data` as `moorl_fb_form.media.metaData`, `moorl_fb_form.media`.`config` as `moorl_fb_form.media.config`, `moorl_fb_form.media`.`path` as `moorl_fb_form.media.path`, `moorl_fb_form.media`.`private` as `moorl_fb_form.media.private`, `moorl_fb_form.media`.`thumbnails_ro` as `moorl_fb_form.media.thumbnailsRo`, `moorl_fb_form.media`.`created_at` as `moorl_fb_form.media.createdAt`, `moorl_fb_form.media`.`updated_at` as `moorl_fb_form.media.updatedAt`, `moorl_fb_form.media.translation.title`, COALESCE(`moorl_fb_form.media.translation.title`,`moorl_fb_form.media.translation.title`) as `moorl_fb_form.media.title`, `moorl_fb_form.media.translation.alt`, COALESCE(`moorl_fb_form.media.translation.alt`,`moorl_fb_form.media.translation.alt`) as `moorl_fb_form.media.alt`, `moorl_fb_form.media.translation.customFields`, COALESCE(`moorl_fb_form.media.translation.customFields`,`moorl_fb_form.media.translation.customFields`) as `moorl_fb_form.media.customFields`, `moorl_fb_form.media.translation.createdAt`, `moorl_fb_form.media.translation.updatedAt`, `moorl_fb_form.media.translation.mediaId`, `moorl_fb_form.media.translation.languageId`, `moorl_fb_form`.`created_at` as `moorl_fb_form.createdAt`, `moorl_fb_form`.`updated_at` as `moorl_fb_form.updatedAt`, `moorl_fb_form.translation.name`, COALESCE(`moorl_fb_form.translation.name`,`moorl_fb_form.translation.name`) as `moorl_fb_form.name`, `moorl_fb_form.translation.successMessage`, COALESCE(`moorl_fb_form.translation.successMessage`,`moorl_fb_form.translation.successMessage`) as `moorl_fb_form.successMessage`, `moorl_fb_form.translation.errorMessage`, COALESCE(`moorl_fb_form.translation.errorMessage`,`moorl_fb_form.translation.errorMessage`) as `moorl_fb_form.errorMessage`, `moorl_fb_form.translation.custom1`, COALESCE(`moorl_fb_form.translation.custom1`,`moorl_fb_form.translation.custom1`) as `moorl_fb_form.custom1`, `moorl_fb_form.translation.custom2`, COALESCE(`moorl_fb_form.translation.custom2`,`moorl_fb_form.translation.custom2`) as `moorl_fb_form.custom2`, `moorl_fb_form.translation.mailReceiver`, COALESCE(`moorl_fb_form.translation.mailReceiver`,`moorl_fb_form.translation.mailReceiver`) as `moorl_fb_form.mailReceiver`, `moorl_fb_form.translation.storefrontTemplate`, COALESCE(`moorl_fb_form.translation.storefrontTemplate`,`moorl_fb_form.translation.storefrontTemplate`) as `moorl_fb_form.storefrontTemplate`, `moorl_fb_form.translation.createdAt`, `moorl_fb_form.translation.updatedAt`, `moorl_fb_form.translation.moorlFbFormId`, `moorl_fb_form.translation.languageId` FROM `moorl_fb_form` LEFT JOIN (SELECT `moorl_fb_form.translation`.moorl_fb_form_id, `moorl_fb_form.translation`.name as `moorl_fb_form.translation.name`, `moorl_fb_form.translation`.success_message as `moorl_fb_form.translation.successMessage`, `moorl_fb_form.translation`.error_message as `moorl_fb_form.translation.errorMessage`, `moorl_fb_form.translation`.custom1 as `moorl_fb_form.translation.custom1`, `moorl_fb_form.translation`.custom2 as `moorl_fb_form.translation.custom2`, `moorl_fb_form.translation`.mail_receiver as `moorl_fb_form.translation.mailReceiver`, `moorl_fb_form.translation`.storefront_template as `moorl_fb_form.translation.storefrontTemplate`, `moorl_fb_form.translation`.created_at as `moorl_fb_form.translation.createdAt`, `moorl_fb_form.translation`.updated_at as `moorl_fb_form.translation.updatedAt`, `moorl_fb_form.translation`.moorl_fb_form_id as `moorl_fb_form.translation.moorlFbFormId`, `moorl_fb_form.translation`.language_id as `moorl_fb_form.translation.languageId` FROM `moorl_fb_form_translation` `moorl_fb_form.translation` WHERE `moorl_fb_form.translation`.language_id = ?) `moorl_fb_form.moorl_fb_form_translation` ON `moorl_fb_form.moorl_fb_form_translation`.`moorl_fb_form_id` = `moorl_fb_form`.`id` LEFT JOIN `tax` `moorl_fb_form.tax` ON `moorl_fb_form`.`tax_id` = `moorl_fb_form.tax`.`id` LEFT JOIN `media` `moorl_fb_form.media` ON `moorl_fb_form`.`media_id` = `moorl_fb_form.media`.`id` LEFT JOIN (SELECT `moorl_fb_form.media.translation`.media_id, `moorl_fb_form.media.translation`.title as `moorl_fb_form.media.translation.title`, `moorl_fb_form.media.translation`.alt as `moorl_fb_form.media.translation.alt`, `moorl_fb_form.media.translation`.custom_fields as `moorl_fb_form.media.translation.customFields`, `moorl_fb_form.media.translation`.created_at as `moorl_fb_form.media.translation.createdAt`, `moorl_fb_form.media.translation`.updated_at as `moorl_fb_form.media.translation.updatedAt`, `moorl_fb_form.media.translation`.media_id as `moorl_fb_form.media.translation.mediaId`, `moorl_fb_form.media.translation`.language_id as `moorl_fb_form.media.translation.languageId` FROM `media_translation` `moorl_fb_form.media.translation` WHERE `moorl_fb_form.media.translation`.language_id = ?) `moorl_fb_form.media.media_translation` ON `moorl_fb_form.media.media_translation`.`media_id` = `moorl_fb_form.media`.`id` WHERE ((`moorl_fb_form`.`active` = ? AND (`moorl_fb_form`.`show_from` <=> ? OR (`moorl_fb_form`.`show_from` <= ?)) AND (`moorl_fb_form`.`show_until` <=> ? OR (`moorl_fb_form`.`show_until` >= ?)) AND (`moorl_fb_form`.`sales_channel_id` <=> ? OR `moorl_fb_form`.`sales_channel_id` = ?) AND (`moorl_fb_form`.`language_id` <=> ? OR `moorl_fb_form`.`language_id` = ?) AND (`moorl_fb_form`.`customer_group_id` <=> ? OR `moorl_fb_form`.`customer_group_id` = ?) AND (`moorl_fb_form`.`country_id` <=> ? OR `moorl_fb_form`.`country_id` = ?) AND (`moorl_fb_form`.`payment_method_id` <=> ? OR `moorl_fb_form`.`payment_method_id` = ?) AND (`moorl_fb_form`.`shipping_method_id` <=> ? OR `moorl_fb_form`.`shipping_method_id` = ?)) AND `moorl_fb_form`.`related_entity` = ?)
SELECT `moorl_fb_element`.`id` as `moorl_fb_element.id`, `moorl_fb_element`.`parent_id` as `moorl_fb_element.parentId`, `moorl_fb_element`.`after_id` as `moorl_fb_element.afterId`, `moorl_fb_element`.`moorl_fb_form_id` as `moorl_fb_element.formId`, `moorl_fb_element`.`tax_id` as `moorl_fb_element.taxId`, `moorl_fb_element`.`user_id` as `moorl_fb_element.userId`, `moorl_fb_element`.`media_id` as `moorl_fb_element.mediaId`, `moorl_fb_element`.`sales_channel_id` as `moorl_fb_element.salesChannelId`, `moorl_fb_element`.`product_stream_id` as `moorl_fb_element.productStreamId`, `moorl_fb_element`.`customer_group_id` as `moorl_fb_element.customerGroupId`, `moorl_fb_element`.`shipping_method_id` as `moorl_fb_element.shippingMethodId`, `moorl_fb_element`.`payment_method_id` as `moorl_fb_element.paymentMethodId`, `moorl_fb_element`.`country_id` as `moorl_fb_element.countryId`, `moorl_fb_element`.`language_id` as `moorl_fb_element.languageId`, `moorl_fb_element`.`show_from` as `moorl_fb_element.showFrom`, `moorl_fb_element`.`show_until` as `moorl_fb_element.showUntil`, `moorl_fb_element`.`child_count` as `moorl_fb_element.childCount`, `moorl_fb_element`.`level` as `moorl_fb_element.level`, `moorl_fb_element`.`path` as `moorl_fb_element.path`, `moorl_fb_element`.`type` as `moorl_fb_element.type`, `moorl_fb_element`.`active` as `moorl_fb_element.active`, `moorl_fb_element`.`visible` as `moorl_fb_element.visible`, `moorl_fb_element`.`disabled` as `moorl_fb_element.disabled`, `moorl_fb_element`.`order` as `moorl_fb_element.order`, `moorl_fb_element`.`maxlength` as `moorl_fb_element.maxlength`, `moorl_fb_element`.`minlength` as `moorl_fb_element.minlength`, `moorl_fb_element`.`required` as `moorl_fb_element.required`, `moorl_fb_element`.`technical_name` as `moorl_fb_element.technicalName`, `moorl_fb_element`.`color` as `moorl_fb_element.color`, `moorl_fb_element`.`email_receiver` as `moorl_fb_element.emailReceiver`, `moorl_fb_element`.`entity_mapping` as `moorl_fb_element.entityMapping`, `moorl_fb_element`.`pattern` as `moorl_fb_element.pattern`, `moorl_fb_element`.`selection` as `moorl_fb_element.selection`, `moorl_fb_element`.`config` as `moorl_fb_element.config`, `moorl_fb_element`.`behaviour` as `moorl_fb_element.behaviour`, `moorl_fb_element`.`conditions` as `moorl_fb_element.conditions`, `moorl_fb_element`.`animation` as `moorl_fb_element.animation`, `moorl_fb_element`.`option_price` as `moorl_fb_element.optionPrice`, `moorl_fb_element`.`option_type` as `moorl_fb_element.optionType`, `moorl_fb_element`.`option_percentage` as `moorl_fb_element.optionPercentage`, `moorl_fb_element.media`.`id` as `moorl_fb_element.media.id`, `moorl_fb_element.media`.`user_id` as `moorl_fb_element.media.userId`, `moorl_fb_element.media`.`media_folder_id` as `moorl_fb_element.media.mediaFolderId`, `moorl_fb_element.media`.`mime_type` as `moorl_fb_element.media.mimeType`, `moorl_fb_element.media`.`file_extension` as `moorl_fb_element.media.fileExtension`, `moorl_fb_element.media`.`uploaded_at` as `moorl_fb_element.media.uploadedAt`, `moorl_fb_element.media`.`file_name` as `moorl_fb_element.media.fileName`, `moorl_fb_element.media`.`file_size` as `moorl_fb_element.media.fileSize`, `moorl_fb_element.media`.`media_type` as `moorl_fb_element.media.mediaTypeRaw`, `moorl_fb_element.media`.`meta_data` as `moorl_fb_element.media.metaData`, `moorl_fb_element.media`.`config` as `moorl_fb_element.media.config`, `moorl_fb_element.media`.`path` as `moorl_fb_element.media.path`, `moorl_fb_element.media`.`private` as `moorl_fb_element.media.private`, `moorl_fb_element.media`.`thumbnails_ro` as `moorl_fb_element.media.thumbnailsRo`, `moorl_fb_element.media`.`created_at` as `moorl_fb_element.media.createdAt`, `moorl_fb_element.media`.`updated_at` as `moorl_fb_element.media.updatedAt`, `moorl_fb_element.media.translation.title`, COALESCE(`moorl_fb_element.media.translation.title`,`moorl_fb_element.media.translation.title`) as `moorl_fb_element.media.title`, `moorl_fb_element.media.translation.alt`, COALESCE(`moorl_fb_element.media.translation.alt`,`moorl_fb_element.media.translation.alt`) as `moorl_fb_element.media.alt`, `moorl_fb_element.media.translation.customFields`, COALESCE(`moorl_fb_element.media.translation.customFields`,`moorl_fb_element.media.translation.customFields`) as `moorl_fb_element.media.customFields`, `moorl_fb_element.media.translation.createdAt`, `moorl_fb_element.media.translation.updatedAt`, `moorl_fb_element.media.translation.mediaId`, `moorl_fb_element.media.translation.languageId`, `moorl_fb_element`.`created_at` as `moorl_fb_element.createdAt`, `moorl_fb_element`.`updated_at` as `moorl_fb_element.updatedAt`, `moorl_fb_element.translation.name`, COALESCE(`moorl_fb_element.translation.name`,`moorl_fb_element.translation.name`) as `moorl_fb_element.name`, `moorl_fb_element.translation.content`, COALESCE(`moorl_fb_element.translation.content`,`moorl_fb_element.translation.content`) as `moorl_fb_element.content`, `moorl_fb_element.translation.tooltip`, COALESCE(`moorl_fb_element.translation.tooltip`,`moorl_fb_element.translation.tooltip`) as `moorl_fb_element.tooltip`, `moorl_fb_element.translation.prepend`, COALESCE(`moorl_fb_element.translation.prepend`,`moorl_fb_element.translation.prepend`) as `moorl_fb_element.prepend`, `moorl_fb_element.translation.append`, COALESCE(`moorl_fb_element.translation.append`,`moorl_fb_element.translation.append`) as `moorl_fb_element.append`, `moorl_fb_element.translation.placeholder`, COALESCE(`moorl_fb_element.translation.placeholder`,`moorl_fb_element.translation.placeholder`) as `moorl_fb_element.placeholder`, `moorl_fb_element.translation.defaultValue`, COALESCE(`moorl_fb_element.translation.defaultValue`,`moorl_fb_element.translation.defaultValue`) as `moorl_fb_element.defaultValue`, `moorl_fb_element.translation.custom1`, COALESCE(`moorl_fb_element.translation.custom1`,`moorl_fb_element.translation.custom1`) as `moorl_fb_element.custom1`, `moorl_fb_element.translation.custom2`, COALESCE(`moorl_fb_element.translation.custom2`,`moorl_fb_element.translation.custom2`) as `moorl_fb_element.custom2`, `moorl_fb_element.translation.custom3`, COALESCE(`moorl_fb_element.translation.custom3`,`moorl_fb_element.translation.custom3`) as `moorl_fb_element.custom3`, `moorl_fb_element.translation.custom4`, COALESCE(`moorl_fb_element.translation.custom4`,`moorl_fb_element.translation.custom4`) as `moorl_fb_element.custom4`, `moorl_fb_element.translation.mailReceiver`, COALESCE(`moorl_fb_element.translation.mailReceiver`,`moorl_fb_element.translation.mailReceiver`) as `moorl_fb_element.mailReceiver`, `moorl_fb_element.translation.customFields`, COALESCE(`moorl_fb_element.translation.customFields`,`moorl_fb_element.translation.customFields`) as `moorl_fb_element.customFields`, `moorl_fb_element.translation.createdAt`, `moorl_fb_element.translation.updatedAt`, `moorl_fb_element.translation.moorlFbElementId`, `moorl_fb_element.translation.languageId` FROM `moorl_fb_element` LEFT JOIN (SELECT `moorl_fb_element.translation`.moorl_fb_element_id, `moorl_fb_element.translation`.name as `moorl_fb_element.translation.name`, `moorl_fb_element.translation`.content as `moorl_fb_element.translation.content`, `moorl_fb_element.translation`.tooltip as `moorl_fb_element.translation.tooltip`, `moorl_fb_element.translation`.prepend as `moorl_fb_element.translation.prepend`, `moorl_fb_element.translation`.append as `moorl_fb_element.translation.append`, `moorl_fb_element.translation`.placeholder as `moorl_fb_element.translation.placeholder`, `moorl_fb_element.translation`.default_value as `moorl_fb_element.translation.defaultValue`, `moorl_fb_element.translation`.custom1 as `moorl_fb_element.translation.custom1`, `moorl_fb_element.translation`.custom2 as `moorl_fb_element.translation.custom2`, `moorl_fb_element.translation`.custom3 as `moorl_fb_element.translation.custom3`, `moorl_fb_element.translation`.custom4 as `moorl_fb_element.translation.custom4`, `moorl_fb_element.translation`.mail_receiver as `moorl_fb_element.translation.mailReceiver`, `moorl_fb_element.translation`.custom_fields as `moorl_fb_element.translation.customFields`, `moorl_fb_element.translation`.created_at as `moorl_fb_element.translation.createdAt`, `moorl_fb_element.translation`.updated_at as `moorl_fb_element.translation.updatedAt`, `moorl_fb_element.translation`.moorl_fb_element_id as `moorl_fb_element.translation.moorlFbElementId`, `moorl_fb_element.translation`.language_id as `moorl_fb_element.translation.languageId` FROM `moorl_fb_element_translation` `moorl_fb_element.translation` WHERE `moorl_fb_element.translation`.language_id = ?) `moorl_fb_element.moorl_fb_element_translation` ON `moorl_fb_element.moorl_fb_element_translation`.`moorl_fb_element_id` = `moorl_fb_element`.`id` LEFT JOIN `media` `moorl_fb_element.media` ON `moorl_fb_element`.`media_id` = `moorl_fb_element.media`.`id` LEFT JOIN (SELECT `moorl_fb_element.media.translation`.media_id, `moorl_fb_element.media.translation`.title as `moorl_fb_element.media.translation.title`, `moorl_fb_element.media.translation`.alt as `moorl_fb_element.media.translation.alt`, `moorl_fb_element.media.translation`.custom_fields as `moorl_fb_element.media.translation.customFields`, `moorl_fb_element.media.translation`.created_at as `moorl_fb_element.media.translation.createdAt`, `moorl_fb_element.media.translation`.updated_at as `moorl_fb_element.media.translation.updatedAt`, `moorl_fb_element.media.translation`.media_id as `moorl_fb_element.media.translation.mediaId`, `moorl_fb_element.media.translation`.language_id as `moorl_fb_element.media.translation.languageId` FROM `media_translation` `moorl_fb_element.media.translation` WHERE `moorl_fb_element.media.translation`.language_id = ?) `moorl_fb_element.media.media_translation` ON `moorl_fb_element.media.media_translation`.`media_id` = `moorl_fb_element.media`.`id` WHERE ((`moorl_fb_element`.`active` = ? AND (`moorl_fb_element`.`show_from` <=> ? OR (`moorl_fb_element`.`show_from` <= ?)) AND (`moorl_fb_element`.`show_until` <=> ? OR (`moorl_fb_element`.`show_until` >= ?)) AND (`moorl_fb_element`.`sales_channel_id` <=> ? OR `moorl_fb_element`.`sales_channel_id` = ?) AND (`moorl_fb_element`.`customer_group_id` <=> ? OR `moorl_fb_element`.`customer_group_id` = ?) AND (`moorl_fb_element`.`country_id` <=> ? OR `moorl_fb_element`.`country_id` = ?) AND (`moorl_fb_element`.`payment_method_id` <=> ? OR `moorl_fb_element`.`payment_method_id` = ?) AND (`moorl_fb_element`.`shipping_method_id` <=> ? OR `moorl_fb_element`.`shipping_method_id` = ?)) AND `moorl_fb_element`.`moorl_fb_form_id` IN (?, ?))
SELECT module.module, module.response FROM wbm_data_layer_modules module
# product-detail-route::check-variant-listing-config
            SELECT
                variant_listing_config as variantListingConfig,
                parent_id as parentId
            FROM product
            WHERE id = ?
            AND version_id = ?
SELECT `acris_category_customer_group`.`category_id`, `acris_category_customer_group`.`customer_group_id` FROM `acris_category_customer_group` WHERE (`acris_category_customer_group`.`customer_group_id` = ?)
# product-detail-route::find-best-variant::search-ids
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 (SELECT `product.categoriesRo.mapping`.`product_id` as id, `product.categoriesRo.mapping`.`product_version_id` FROM `product_category_tree` `product.categoriesRo.mapping` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product.categoriesRo`.`id` IN (?, ?))) `product.categoriesRo_1` ON `product`.`id` = `product.categoriesRo_1`.`id` AND `product`.`version_id` = `product.categoriesRo_1`.`product_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`.`parent_id` = ? AND (NOT (`product.categoriesRo_1`.id IS NOT NULL)) AND ((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) ORDER BY `product`.`available` DESC, IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC LIMIT 1
# product-detail-route::search-ids
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 LEFT JOIN (SELECT `product.categoriesRo.mapping`.`product_id` as id, `product.categoriesRo.mapping`.`product_version_id` FROM `product_category_tree` `product.categoriesRo.mapping` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product.categoriesRo`.`id` IN (?, ?))) `product.categoriesRo_1` ON `product`.`id` = `product.categoriesRo_1`.`id` AND `product`.`version_id` = `product.categoriesRo_1`.`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 (NOT (`product.categoriesRo_1`.id IS NOT NULL)))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT COUNT(*) FROM `wallee_transaction` LIMIT 1
Database Connections

Name	Service
0	default
Entity Managers

There are no configured entity managers.
Second Level Cache

Second Level Cache is not enabled.
Symfony Profiler

GET http://emmi-pet.bm.media/detail/0134cf9aae07467dbf409ef565d4b22a

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache
