POST https://wein-moment.de/api/search/order

Response
200 OK
IP
5.45.144.85
Profiled on
Token
306843

Query Metrics

22 Database Queries
19 Different statements
14.05 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
2.40 ms
(17.07%) 		1 
SELECT `order`.`id` as `order.id`, `order`.`version_id` as `order.versionId`, `order`.`auto_increment` as `order.autoIncrement`, `order`.`order_number` as `order.orderNumber`, `order`.`billing_address_id` as `order.billingAddressId`, `order`.`billing_address_version_id` as `order.billingAddressVersionId`, `order`.`primary_order_delivery_id` as `order.primaryOrderDeliveryId`, `order`.`primary_order_delivery_version_id` as `order.primaryOrderDeliveryVersionId`, `order`.`primary_order_transaction_id` as `order.primaryOrderTransactionId`, `order`.`primary_order_transaction_version_id` as `order.primaryOrderTransactionVersionId`, `order`.`currency_id` as `order.currencyId`, `order`.`language_id` as `order.languageId`, `order`.`sales_channel_id` as `order.salesChannelId`, `order`.`order_date_time` as `order.orderDateTime`, `order`.`order_date` as `order.orderDate`, `order`.`price` as `order.price`, `order`.`amount_total` as `order.amountTotal`, `order`.`amount_net` as `order.amountNet`, `order`.`position_price` as `order.positionPrice`, `order`.`tax_status` as `order.taxStatus`, `order`.`shipping_costs` as `order.shippingCosts`, `order`.`shipping_total` as `order.shippingTotal`, `order`.`currency_factor` as `order.currencyFactor`, `order`.`deep_link_code` as `order.deepLinkCode`, `order`.`affiliate_code` as `order.affiliateCode`, `order`.`campaign_code` as `order.campaignCode`, `order`.`customer_comment` as `order.customerComment`, `order`.`internal_comment` as `order.internalComment`, `order`.`source` as `order.source`, `order`.`tax_calculation_type` as `order.taxCalculationType`, `order`.`state_id` as `order.stateId`, `order`.`rule_ids` as `order.ruleIds`, `order`.`custom_fields` as `order.customFields`, `order`.`created_by_id` as `order.createdById`, `order`.`updated_by_id` as `order.updatedById`, `order.orderCustomer`.`id` as `order.orderCustomer.id`, `order.orderCustomer`.`version_id` as `order.orderCustomer.versionId`, `order.orderCustomer`.`customer_id` as `order.orderCustomer.customerId`, `order.orderCustomer`.`order_id` as `order.orderCustomer.orderId`, `order.orderCustomer`.`order_version_id` as `order.orderCustomer.orderVersionId`, `order.orderCustomer`.`email` as `order.orderCustomer.email`, `order.orderCustomer`.`salutation_id` as `order.orderCustomer.salutationId`, `order.orderCustomer`.`first_name` as `order.orderCustomer.firstName`, `order.orderCustomer`.`last_name` as `order.orderCustomer.lastName`, `order.orderCustomer`.`company` as `order.orderCustomer.company`, `order.orderCustomer`.`title` as `order.orderCustomer.title`, `order.orderCustomer`.`vat_ids` as `order.orderCustomer.vatIds`, `order.orderCustomer`.`customer_number` as `order.orderCustomer.customerNumber`, `order.orderCustomer`.`custom_fields` as `order.orderCustomer.customFields`, `order.orderCustomer`.`remote_address` as `order.orderCustomer.remoteAddress`, `order.orderCustomer`.`created_at` as `order.orderCustomer.createdAt`, `order.orderCustomer`.`updated_at` as `order.orderCustomer.updatedAt`, `order`.`item_rounding` as `order.itemRounding`, `order`.`total_rounding` as `order.totalRounding`, `order`.`created_at` as `order.createdAt`, `order`.`updated_at` as `order.updatedAt`, `order.netiStorePickupSelectedStore`.`id` as `order.netiStorePickupSelectedStore.id`, `order.netiStorePickupSelectedStore`.`version_id` as `order.netiStorePickupSelectedStore.versionId`, `order.netiStorePickupSelectedStore`.`store_id` as `order.netiStorePickupSelectedStore.storeId`, `order.netiStorePickupSelectedStore`.`order_id` as `order.netiStorePickupSelectedStore.orderId`, `order.netiStorePickupSelectedStore`.`pick_up_date_time` as `order.netiStorePickupSelectedStore.pickUpDateTime`, `order.netiStorePickupSelectedStore`.`selection_type` as `order.netiStorePickupSelectedStore.selectionType`, `order.netiStorePickupSelectedStore`.`date_format` as `order.netiStorePickupSelectedStore.dateFormat`, `order.netiStorePickupSelectedStore`.`updated_at` as `order.netiStorePickupSelectedStore.updatedAt`, `order.netiStorePickupSelectedStore`.`created_at` as `order.netiStorePickupSelectedStore.createdAt`, `order.netiStorePickupSelectedStore.store`.`id` as `order.netiStorePickupSelectedStore.store.id`, `order.netiStorePickupSelectedStore.store`.`street` as `order.netiStorePickupSelectedStore.store.street`, `order.netiStorePickupSelectedStore.store`.`street_number` as `order.netiStorePickupSelectedStore.store.streetNumber`, `order.netiStorePickupSelectedStore.store`.`zip_code` as `order.netiStorePickupSelectedStore.store.zipCode`, `order.netiStorePickupSelectedStore.store`.`city` as `order.netiStorePickupSelectedStore.store.city`, `order.netiStorePickupSelectedStore.store`.`address_hash` as `order.netiStorePickupSelectedStore.store.addressHash`, `order.netiStorePickupSelectedStore.store`.`longitude` as `order.netiStorePickupSelectedStore.store.longitude`, `order.netiStorePickupSelectedStore.store`.`latitude` as `order.netiStorePickupSelectedStore.store.latitude`, `order.netiStorePickupSelectedStore.store`.`timezone` as `order.netiStorePickupSelectedStore.store.timezone`, `order.netiStorePickupSelectedStore.store`.`phone` as `order.netiStorePickupSelectedStore.store.phone`, `order.netiStorePickupSelectedStore.store`.`fax` as `order.netiStorePickupSelectedStore.store.fax`, `order.netiStorePickupSelectedStore.store`.`infobox_mode` as `order.netiStorePickupSelectedStore.store.infoboxMode`, `order.netiStorePickupSelectedStore.store`.`url` as `order.netiStorePickupSelectedStore.store.url`, `order.netiStorePickupSelectedStore.store`.`url_label` as `order.netiStorePickupSelectedStore.store.urlLabel`, `order.netiStorePickupSelectedStore.store`.`email` as `order.netiStorePickupSelectedStore.store.email`, `order.netiStorePickupSelectedStore.store`.`country_id` as `order.netiStorePickupSelectedStore.store.countryId`, `order.netiStorePickupSelectedStore.store`.`country_state_id` as `order.netiStorePickupSelectedStore.store.countryStateId`, `order.netiStorePickupSelectedStore.store`.`active` as `order.netiStorePickupSelectedStore.store.active`, `order.netiStorePickupSelectedStore.store`.`contact_form_enabled` as `order.netiStorePickupSelectedStore.store.contactFormEnabled`, `order.netiStorePickupSelectedStore.store`.`contact_form_detail` as `order.netiStorePickupSelectedStore.store.contactFormDetail`, `order.netiStorePickupSelectedStore.store`.`hidden` as `order.netiStorePickupSelectedStore.store.hidden`, `order.netiStorePickupSelectedStore.store`.`notification_email` as `order.netiStorePickupSelectedStore.store.notificationMailAddress`, `order.netiStorePickupSelectedStore.store`.`show_always` as `order.netiStorePickupSelectedStore.store.showAlways`, `order.netiStorePickupSelectedStore.store`.`zoom` as `order.netiStorePickupSelectedStore.store.zoom`, `order.netiStorePickupSelectedStore.store`.`exclude_from_sync` as `order.netiStorePickupSelectedStore.store.excludeFromSync`, `order.netiStorePickupSelectedStore.store`.`google_place_id` as `order.netiStorePickupSelectedStore.store.googlePlaceID`, `order.netiStorePickupSelectedStore.store`.`featured` as `order.netiStorePickupSelectedStore.store.featured`, `order.netiStorePickupSelectedStore.store`.`radius` as `order.netiStorePickupSelectedStore.store.radius`, `order.netiStorePickupSelectedStore.store`.`detail_page_enabled` as `order.netiStorePickupSelectedStore.store.detailPageEnabled`, `order.netiStorePickupSelectedStore.store`.`detail_content_type` as `order.netiStorePickupSelectedStore.store.detailContentType`, `order.netiStorePickupSelectedStore.store`.`detail_in_sitemap` as `order.netiStorePickupSelectedStore.store.detailInSitemap`, `order.netiStorePickupSelectedStore.store`.`picture_media_id` as `order.netiStorePickupSelectedStore.store.pictureMediaId`, `order.netiStorePickupSelectedStore.store`.`details_picture_media_id` as `order.netiStorePickupSelectedStore.store.detailsPictureMediaId`, `order.netiStorePickupSelectedStore.store`.`icon_media_id` as `order.netiStorePickupSelectedStore.store.iconMediaId`, `order.netiStorePickupSelectedStore.store`.`external_id` as `order.netiStorePickupSelectedStore.store.externalId`, `order.netiStorePickupSelectedStore.store`.`created_at` as `order.netiStorePickupSelectedStore.store.createdAt`, `order.netiStorePickupSelectedStore.store`.`updated_at` as `order.netiStorePickupSelectedStore.store.updatedAt`, `order.netiStorePickupSelectedStore.store.translation.label`, `order.netiStorePickupSelectedStore.store.translation.label` as `order.netiStorePickupSelectedStore.store.label`, `order.netiStorePickupSelectedStore.store.translation.description`, `order.netiStorePickupSelectedStore.store.translation.description` as `order.netiStorePickupSelectedStore.store.description`, `order.netiStorePickupSelectedStore.store.translation.additionalInformation`, `order.netiStorePickupSelectedStore.store.translation.additionalInformation` as `order.netiStorePickupSelectedStore.store.additionalInformation`, `order.netiStorePickupSelectedStore.store.translation.seoTitle`, `order.netiStorePickupSelectedStore.store.translation.seoTitle` as `order.netiStorePickupSelectedStore.store.seoTitle`, `order.netiStorePickupSelectedStore.store.translation.seoUrl`, `order.netiStorePickupSelectedStore.store.translation.seoUrl` as `order.netiStorePickupSelectedStore.store.seoUrl`, `order.netiStorePickupSelectedStore.store.translation.seoDescription`, `order.netiStorePickupSelectedStore.store.translation.seoDescription` as `order.netiStorePickupSelectedStore.store.seoDescription`, `order.netiStorePickupSelectedStore.store.translation.detailTitle`, `order.netiStorePickupSelectedStore.store.translation.detailTitle` as `order.netiStorePickupSelectedStore.store.detailTitle`, `order.netiStorePickupSelectedStore.store.translation.detailDescription`, `order.netiStorePickupSelectedStore.store.translation.detailDescription` as `order.netiStorePickupSelectedStore.store.detailDescription`, `order.netiStorePickupSelectedStore.store.translation.openingTimes`, `order.netiStorePickupSelectedStore.store.translation.openingTimes` as `order.netiStorePickupSelectedStore.store.openingTimes`, `order.netiStorePickupSelectedStore.store.translation.infoboxContent`, `order.netiStorePickupSelectedStore.store.translation.infoboxContent` as `order.netiStorePickupSelectedStore.store.infoboxContent`, `order.netiStorePickupSelectedStore.store.translation.customFields`, `order.netiStorePickupSelectedStore.store.translation.customFields` as `order.netiStorePickupSelectedStore.store.customFields` FROM `order` LEFT JOIN `order_customer` `order.orderCustomer` ON `order`.`id` = `order.orderCustomer`.`order_id` AND `order`.`version_id` = `order.orderCustomer`.`order_version_id` LEFT JOIN `neti_store_pickup_order_attribute` `order.netiStorePickupSelectedStore` ON `order`.`id` = `order.netiStorePickupSelectedStore`.`order_id` AND `order.netiStorePickupSelectedStore`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN `neti_store_locator` `order.netiStorePickupSelectedStore.store` ON `order.netiStorePickupSelectedStore`.`store_id` = `order.netiStorePickupSelectedStore.store`.`id` LEFT JOIN (SELECT `order.netiStorePickupSelectedStore.store.translation`.`neti_store_locator_id`, `order.netiStorePickupSelectedStore.store.translation`.`description` as `order.netiStorePickupSelectedStore.store.translation.description`, `order.netiStorePickupSelectedStore.store.translation`.`additional_information` as `order.netiStorePickupSelectedStore.store.translation.additionalInformation`, `order.netiStorePickupSelectedStore.store.translation`.`label` as `order.netiStorePickupSelectedStore.store.translation.label`, `order.netiStorePickupSelectedStore.store.translation`.`seo_title` as `order.netiStorePickupSelectedStore.store.translation.seoTitle`, `order.netiStorePickupSelectedStore.store.translation`.`seo_url` as `order.netiStorePickupSelectedStore.store.translation.seoUrl`, `order.netiStorePickupSelectedStore.store.translation`.`seo_description` as `order.netiStorePickupSelectedStore.store.translation.seoDescription`, `order.netiStorePickupSelectedStore.store.translation`.`detail_title` as `order.netiStorePickupSelectedStore.store.translation.detailTitle`, `order.netiStorePickupSelectedStore.store.translation`.`detail_description` as `order.netiStorePickupSelectedStore.store.translation.detailDescription`, `order.netiStorePickupSelectedStore.store.translation`.`opening_times` as `order.netiStorePickupSelectedStore.store.translation.openingTimes`, `order.netiStorePickupSelectedStore.store.translation`.`infobox_content` as `order.netiStorePickupSelectedStore.store.translation.infoboxContent`, `order.netiStorePickupSelectedStore.store.translation`.`custom_fields` as `order.netiStorePickupSelectedStore.store.translation.customFields` FROM `neti_store_locator_translation` `order.netiStorePickupSelectedStore.store.translation` WHERE `order.netiStorePickupSelectedStore.store.translation`.`language_id` = ?) `order.netiStorePickupSelectedStore.store.neti_store_locator_translation` ON `order.netiStorePickupSelectedStore.store.neti_store_locator_translation`.`neti_store_locator_id` = `order.netiStorePickupSelectedStore.store`.`id` WHERE (`order`.`version_id` = ?) AND (`order`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01w¶Ã\x0Ep9ªÃ?Çrû–\x04"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.37 ms
(16.86%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.11 ms
(7.91%) 		2 
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`.`context_gateway_url` as `app.contextGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`requested_privileges` as `app.requestedPrivileges`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01š0I„Gpg”àò±@²yÚ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.86 ms
(6.12%) 		2 
SELECT configuration_value FROM system_config WHERE sales_channel_id IS NULL and configuration_key IN (?)
Parameters: 
[
  "core.mailerSettings.emailAgent"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(4.81%) 		1 
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;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(4.66%) 		1 
SELECT `order_transaction`.`id` as `order_transaction.id`, `order_transaction`.`version_id` as `order_transaction.versionId`, `order_transaction`.`order_id` as `order_transaction.orderId`, `order_transaction`.`order_version_id` as `order_transaction.orderVersionId`, `order_transaction`.`payment_method_id` as `order_transaction.paymentMethodId`, `order_transaction`.`amount` as `order_transaction.amount`, `order_transaction`.`validation_data` as `order_transaction.validationData`, `order_transaction`.`state_id` as `order_transaction.stateId`, `order_transaction`.`custom_fields` as `order_transaction.customFields`, `order_transaction`.`created_at` as `order_transaction.createdAt`, `order_transaction`.`updated_at` as `order_transaction.updatedAt`, `order_transaction.stateMachineState`.`id` as `order_transaction.stateMachineState.id`, `order_transaction.stateMachineState`.`technical_name` as `order_transaction.stateMachineState.technicalName`, `order_transaction.stateMachineState`.`state_machine_id` as `order_transaction.stateMachineState.stateMachineId`, `order_transaction.stateMachineState`.`created_at` as `order_transaction.stateMachineState.createdAt`, `order_transaction.stateMachineState`.`updated_at` as `order_transaction.stateMachineState.updatedAt`, `order_transaction.stateMachineState.translation.name`, `order_transaction.stateMachineState.translation.name` as `order_transaction.stateMachineState.name`, `order_transaction.stateMachineState.translation.customFields`, `order_transaction.stateMachineState.translation.customFields` as `order_transaction.stateMachineState.customFields` FROM `order_transaction` LEFT JOIN `state_machine_state` `order_transaction.stateMachineState` ON `order_transaction`.`state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN (SELECT `order_transaction.stateMachineState.translation`.`state_machine_state_id`, `order_transaction.stateMachineState.translation`.`name` as `order_transaction.stateMachineState.translation.name`, `order_transaction.stateMachineState.translation`.`custom_fields` as `order_transaction.stateMachineState.translation.customFields` FROM `state_machine_state_translation` `order_transaction.stateMachineState.translation` WHERE `order_transaction.stateMachineState.translation`.`language_id` = ?) `order_transaction.stateMachineState.state_machine_state_translation` ON `order_transaction.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.stateMachineState`.`id` WHERE (`order_transaction`.`version_id` = ?) AND (((`order_transaction`.`order_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01w¶Ã\x0Ep9ªÃ?Çrû–\x04"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.65 ms
(4.60%) 		1 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   `app`.`name` AS appName,
                   `app`.`version` AS appVersion,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   IF(`script`.`active` = 1 AND (`app`.id IS NULL OR `app`.`active` = 1), 1, 0) AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(4.53%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(4.29%) 		1 
SELECT `order_delivery`.`id` as `order_delivery.id`, `order_delivery`.`version_id` as `order_delivery.versionId`, `order_delivery`.`order_id` as `order_delivery.orderId`, `order_delivery`.`order_version_id` as `order_delivery.orderVersionId`, `order_delivery`.`shipping_order_address_id` as `order_delivery.shippingOrderAddressId`, `order_delivery`.`shipping_order_address_version_id` as `order_delivery.shippingOrderAddressVersionId`, `order_delivery`.`shipping_method_id` as `order_delivery.shippingMethodId`, `order_delivery`.`state_id` as `order_delivery.stateId`, `order_delivery`.`tracking_codes` as `order_delivery.trackingCodes`, `order_delivery`.`shipping_date_earliest` as `order_delivery.shippingDateEarliest`, `order_delivery`.`shipping_date_latest` as `order_delivery.shippingDateLatest`, `order_delivery`.`shipping_costs` as `order_delivery.shippingCosts`, `order_delivery`.`custom_fields` as `order_delivery.customFields`, `order_delivery`.`created_at` as `order_delivery.createdAt`, `order_delivery`.`updated_at` as `order_delivery.updatedAt` FROM `order_delivery` WHERE (`order_delivery`.`version_id` = ?) AND (((`order_delivery`.`order_id` IN (?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01w¶Ã\x0Ep9ªÃ?Çrû–\x04"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(4.07%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(3.98%) 		1 
SELECT item_rounding FROM currency WHERE id = ?
Parameters: 
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(3.77%) 		2 
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 (?)))
Parameters: 
[
  b"\x01š0I„Gpg”àò±@²yÚ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(3.71%) 		1 
-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters: 
[
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(3.70%) 		1 
SELECT `order_line_item`.`id` as `order_line_item.id`, `order_line_item`.`version_id` as `order_line_item.versionId`, `order_line_item`.`order_id` as `order_line_item.orderId`, `order_line_item`.`order_version_id` as `order_line_item.orderVersionId`, `order_line_item`.`product_id` as `order_line_item.productId`, `order_line_item`.`product_version_id` as `order_line_item.productVersionId`, `order_line_item`.`promotion_id` as `order_line_item.promotionId`, `order_line_item`.`parent_id` as `order_line_item.parentId`, `order_line_item`.`parent_version_id` as `order_line_item.parentVersionId`, `order_line_item`.`cover_id` as `order_line_item.coverId`, `order_line_item`.`identifier` as `order_line_item.identifier`, `order_line_item`.`referenced_id` as `order_line_item.referencedId`, `order_line_item`.`quantity` as `order_line_item.quantity`, `order_line_item`.`label` as `order_line_item.label`, `order_line_item`.`payload` as `order_line_item.payload`, `order_line_item`.`good` as `order_line_item.good`, `order_line_item`.`removable` as `order_line_item.removable`, `order_line_item`.`stackable` as `order_line_item.stackable`, `order_line_item`.`position` as `order_line_item.position`, `order_line_item`.`states` as `order_line_item.states`, `order_line_item`.`price` as `order_line_item.price`, `order_line_item`.`price_definition` as `order_line_item.priceDefinition`, `order_line_item`.`unit_price` as `order_line_item.unitPrice`, `order_line_item`.`total_price` as `order_line_item.totalPrice`, `order_line_item`.`description` as `order_line_item.description`, `order_line_item`.`type` as `order_line_item.type`, `order_line_item`.`custom_fields` as `order_line_item.customFields`, `order_line_item`.`created_at` as `order_line_item.createdAt`, `order_line_item`.`updated_at` as `order_line_item.updatedAt` FROM `order_line_item` WHERE (`order_line_item`.`version_id` = ?) AND (((`order_line_item`.`order_id` IN (?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01w¶Ã\x0Ep9ªÃ?Çrû–\x04"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(2.99%) 		1 
# 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`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(2.25%) 		1 
SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = ?
Parameters: 
[
  b"ä­\t½‹ND¯l-Á\x12\x0Eò9"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(1.97%) 		1 
SELECT id FROM integration WHERE access_key = ?
Parameters: 
[
  "SWIAMUPMSXZ1A2UWAWP1DXLSOA"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(1.53%) 		1 
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?
Parameters: 
[
  b"ä­\t½‹ND¯l-Á\x12\x0Eò9"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(1.19%) 		1 
SELECT admin FROM `integration` WHERE id = ?
Parameters: 
[
  b"ä­\t½‹ND¯l-Á\x12\x0Eò9"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.