POST https://abb-dev.tech/api/search/order

Response
200 OK
IP
88.84.141.4
Profiled on
Token
1186b0

Query Metrics

21 Database Queries
19 Different statements
26.04 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
5.02 ms
(19.27%) 		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`, `order_line_item.product`.`id` as `order_line_item.product.id`, `order_line_item.product`.`version_id` as `order_line_item.product.versionId`, `order_line_item.product`.`parent_id` as `order_line_item.product.parentId`, `order_line_item.product`.`parent_version_id` as `order_line_item.product.parentVersionId`, `order_line_item.product`.`product_manufacturer_id` as `order_line_item.product.manufacturerId`, `order_line_item.product`.`product_manufacturer_version_id` as `order_line_item.product.productManufacturerVersionId`, `order_line_item.product`.`unit_id` as `order_line_item.product.unitId`, `order_line_item.product`.`tax_id` as `order_line_item.product.taxId`, `order_line_item.product`.`product_media_id` as `order_line_item.product.coverId`, `order_line_item.product`.`product_media_version_id` as `order_line_item.product.productMediaVersionId`, `order_line_item.product`.`delivery_time_id` as `order_line_item.product.deliveryTimeId`, `order_line_item.product`.`product_feature_set_id` as `order_line_item.product.featureSetId`, `order_line_item.product`.`canonical_product_id` as `order_line_item.product.canonicalProductId`, `order_line_item.product`.`canonical_product_version_id` as `order_line_item.product.canonicalProductVersionId`, `order_line_item.product`.`cms_page_id` as `order_line_item.product.cmsPageId`, `order_line_item.product`.`cms_page_version_id` as `order_line_item.product.cmsPageVersionId`, `order_line_item.product`.`price` as `order_line_item.product.price`, `order_line_item.product`.`product_number` as `order_line_item.product.productNumber`, `order_line_item.product`.`restock_time` as `order_line_item.product.restockTime`, `order_line_item.product`.`auto_increment` as `order_line_item.product.autoIncrement`, `order_line_item.product`.`active` as `order_line_item.product.active`, `order_line_item.product`.`available` as `order_line_item.product.available`, `order_line_item.product`.`is_closeout` as `order_line_item.product.isCloseout`, `order_line_item.product`.`available_stock` as `order_line_item.product.availableStock`, `order_line_item.product`.`stock` as `order_line_item.product.stock`, `order_line_item.product`.`display_group` as `order_line_item.product.displayGroup`, `order_line_item.product`.`variant_listing_config` as `order_line_item.product.variantListingConfig`, `order_line_item.product`.`variant_restrictions` as `order_line_item.product.variantRestrictions`, `order_line_item.product`.`manufacturer_number` as `order_line_item.product.manufacturerNumber`, `order_line_item.product`.`ean` as `order_line_item.product.ean`, `order_line_item.product`.`purchase_steps` as `order_line_item.product.purchaseSteps`, `order_line_item.product`.`max_purchase` as `order_line_item.product.maxPurchase`, `order_line_item.product`.`min_purchase` as `order_line_item.product.minPurchase`, `order_line_item.product`.`purchase_unit` as `order_line_item.product.purchaseUnit`, `order_line_item.product`.`reference_unit` as `order_line_item.product.referenceUnit`, `order_line_item.product`.`shipping_free` as `order_line_item.product.shippingFree`, `order_line_item.product`.`purchase_prices` as `order_line_item.product.purchasePrices`, `order_line_item.product`.`mark_as_topseller` as `order_line_item.product.markAsTopseller`, `order_line_item.product`.`weight` as `order_line_item.product.weight`, `order_line_item.product`.`width` as `order_line_item.product.width`, `order_line_item.product`.`height` as `order_line_item.product.height`, `order_line_item.product`.`length` as `order_line_item.product.length`, `order_line_item.product`.`release_date` as `order_line_item.product.releaseDate`, `order_line_item.product`.`rating_average` as `order_line_item.product.ratingAverage`, `order_line_item.product`.`category_tree` as `order_line_item.product.categoryTree`, `order_line_item.product`.`property_ids` as `order_line_item.product.propertyIds`, `order_line_item.product`.`option_ids` as `order_line_item.product.optionIds`, `order_line_item.product`.`stream_ids` as `order_line_item.product.streamIds`, `order_line_item.product`.`tag_ids` as `order_line_item.product.tagIds`, `order_line_item.product`.`category_ids` as `order_line_item.product.categoryIds`, `order_line_item.product`.`child_count` as `order_line_item.product.childCount`, `order_line_item.product`.`custom_field_set_selection_active` as `order_line_item.product.customFieldSetSelectionActive`, `order_line_item.product`.`sales` as `order_line_item.product.sales`, `order_line_item.product`.`states` as `order_line_item.product.states`, `order_line_item.product.tax`.`id` as `order_line_item.product.tax.id`, `order_line_item.product.tax`.`tax_rate` as `order_line_item.product.tax.taxRate`, `order_line_item.product.tax`.`name` as `order_line_item.product.tax.name`, `order_line_item.product.tax`.`position` as `order_line_item.product.tax.position`, `order_line_item.product.tax`.`custom_fields` as `order_line_item.product.tax.customFields`, `order_line_item.product.tax`.`created_at` as `order_line_item.product.tax.createdAt`, `order_line_item.product.tax`.`updated_at` as `order_line_item.product.tax.updatedAt`, `order_line_item.product`.`created_at` as `order_line_item.product.createdAt`, `order_line_item.product`.`updated_at` as `order_line_item.product.updatedAt`, `order_line_item.product.translation.metaDescription`, `order_line_item.product.translation.metaDescription` as `order_line_item.product.metaDescription`, `order_line_item.product.translation.name`, `order_line_item.product.translation.name` as `order_line_item.product.name`, `order_line_item.product.translation.keywords`, `order_line_item.product.translation.keywords` as `order_line_item.product.keywords`, `order_line_item.product.translation.description`, `order_line_item.product.translation.description` as `order_line_item.product.description`, `order_line_item.product.translation.metaTitle`, `order_line_item.product.translation.metaTitle` as `order_line_item.product.metaTitle`, `order_line_item.product.translation.packUnit`, `order_line_item.product.translation.packUnit` as `order_line_item.product.packUnit`, `order_line_item.product.translation.packUnitPlural`, `order_line_item.product.translation.packUnitPlural` as `order_line_item.product.packUnitPlural`, `order_line_item.product.translation.customSearchKeywords`, `order_line_item.product.translation.customSearchKeywords` as `order_line_item.product.customSearchKeywords`, `order_line_item.product.translation.slotConfig`, `order_line_item.product.translation.slotConfig` as `order_line_item.product.slotConfig`, `order_line_item.product.translation.customFields`, `order_line_item.product.translation.customFields` as `order_line_item.product.customFields` FROM `order_line_item` LEFT JOIN `product` `order_line_item.product` ON `order_line_item`.`product_id` = `order_line_item.product`.`id` AND `order_line_item`.`product_version_id` = `order_line_item.product`.`version_id` LEFT JOIN `tax` `order_line_item.product.tax` ON `order_line_item.product`.`tax_id` = `order_line_item.product.tax`.`id` LEFT JOIN (SELECT `order_line_item.product.translation`.`product_id`, `order_line_item.product.translation`.`product_version_id`, `order_line_item.product.translation`.`meta_description` as `order_line_item.product.translation.metaDescription`, `order_line_item.product.translation`.`name` as `order_line_item.product.translation.name`, `order_line_item.product.translation`.`keywords` as `order_line_item.product.translation.keywords`, `order_line_item.product.translation`.`description` as `order_line_item.product.translation.description`, `order_line_item.product.translation`.`meta_title` as `order_line_item.product.translation.metaTitle`, `order_line_item.product.translation`.`pack_unit` as `order_line_item.product.translation.packUnit`, `order_line_item.product.translation`.`pack_unit_plural` as `order_line_item.product.translation.packUnitPlural`, `order_line_item.product.translation`.`custom_fields` as `order_line_item.product.translation.customFields`, `order_line_item.product.translation`.`slot_config` as `order_line_item.product.translation.slotConfig`, `order_line_item.product.translation`.`custom_search_keywords` as `order_line_item.product.translation.customSearchKeywords` FROM `product_translation` `order_line_item.product.translation` WHERE `order_line_item.product.translation`.`language_id` = ?) `order_line_item.product.product_translation` ON `order_line_item.product.product_translation`.`product_id` = `order_line_item.product`.`id` AND `order_line_item.product.product_translation`.`product_version_id` = `order_line_item.product`.`version_id` WHERE (`order_line_item`.`version_id` = ?) AND ((`order_line_item`.`order_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01“ô=ÎÌsW·þK€Ú½ìÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.98 ms
(11.44%) 		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`.`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`.`source` as `order.source`, `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.orderCustomer.customer`.`id` as `order.orderCustomer.customer.id`, `order.orderCustomer.customer`.`customer_group_id` as `order.orderCustomer.customer.groupId`, `order.orderCustomer.customer`.`sales_channel_id` as `order.orderCustomer.customer.salesChannelId`, `order.orderCustomer.customer`.`language_id` as `order.orderCustomer.customer.languageId`, `order.orderCustomer.customer`.`last_payment_method_id` as `order.orderCustomer.customer.lastPaymentMethodId`, `order.orderCustomer.customer`.`default_billing_address_id` as `order.orderCustomer.customer.defaultBillingAddressId`, `order.orderCustomer.customer`.`default_shipping_address_id` as `order.orderCustomer.customer.defaultShippingAddressId`, `order.orderCustomer.customer`.`auto_increment` as `order.orderCustomer.customer.autoIncrement`, `order.orderCustomer.customer`.`customer_number` as `order.orderCustomer.customer.customerNumber`, `order.orderCustomer.customer`.`salutation_id` as `order.orderCustomer.customer.salutationId`, `order.orderCustomer.customer`.`first_name` as `order.orderCustomer.customer.firstName`, `order.orderCustomer.customer`.`last_name` as `order.orderCustomer.customer.lastName`, `order.orderCustomer.customer`.`company` as `order.orderCustomer.customer.company`, `order.orderCustomer.customer`.`password` as `order.orderCustomer.customer.password`, `order.orderCustomer.customer`.`email` as `order.orderCustomer.customer.email`, `order.orderCustomer.customer`.`title` as `order.orderCustomer.customer.title`, `order.orderCustomer.customer`.`vat_ids` as `order.orderCustomer.customer.vatIds`, `order.orderCustomer.customer`.`affiliate_code` as `order.orderCustomer.customer.affiliateCode`, `order.orderCustomer.customer`.`campaign_code` as `order.orderCustomer.customer.campaignCode`, `order.orderCustomer.customer`.`active` as `order.orderCustomer.customer.active`, `order.orderCustomer.customer`.`double_opt_in_registration` as `order.orderCustomer.customer.doubleOptInRegistration`, `order.orderCustomer.customer`.`double_opt_in_email_sent_date` as `order.orderCustomer.customer.doubleOptInEmailSentDate`, `order.orderCustomer.customer`.`double_opt_in_confirm_date` as `order.orderCustomer.customer.doubleOptInConfirmDate`, `order.orderCustomer.customer`.`hash` as `order.orderCustomer.customer.hash`, `order.orderCustomer.customer`.`guest` as `order.orderCustomer.customer.guest`, `order.orderCustomer.customer`.`first_login` as `order.orderCustomer.customer.firstLogin`, `order.orderCustomer.customer`.`last_login` as `order.orderCustomer.customer.lastLogin`, `order.orderCustomer.customer`.`newsletter_sales_channel_ids` as `order.orderCustomer.customer.newsletterSalesChannelIds`, `order.orderCustomer.customer`.`birthday` as `order.orderCustomer.customer.birthday`, `order.orderCustomer.customer`.`last_order_date` as `order.orderCustomer.customer.lastOrderDate`, `order.orderCustomer.customer`.`order_count` as `order.orderCustomer.customer.orderCount`, `order.orderCustomer.customer`.`order_total_amount` as `order.orderCustomer.customer.orderTotalAmount`, `order.orderCustomer.customer`.`review_count` as `order.orderCustomer.customer.reviewCount`, `order.orderCustomer.customer`.`custom_fields` as `order.orderCustomer.customer.customFields`, `order.orderCustomer.customer`.`legacy_password` as `order.orderCustomer.customer.legacyPassword`, `order.orderCustomer.customer`.`legacy_encoder` as `order.orderCustomer.customer.legacyEncoder`, `order.orderCustomer.customer`.`remote_address` as `order.orderCustomer.customer.remoteAddress`, `order.orderCustomer.customer`.`tag_ids` as `order.orderCustomer.customer.tagIds`, `order.orderCustomer.customer`.`requested_customer_group_id` as `order.orderCustomer.customer.requestedGroupId`, `order.orderCustomer.customer`.`bound_sales_channel_id` as `order.orderCustomer.customer.boundSalesChannelId`, `order.orderCustomer.customer`.`account_type` as `order.orderCustomer.customer.accountType`, `order.orderCustomer.customer`.`created_by_id` as `order.orderCustomer.customer.createdById`, `order.orderCustomer.customer`.`updated_by_id` as `order.orderCustomer.customer.updatedById`, `order.orderCustomer.customer`.`default_payment_method_id` as `order.orderCustomer.customer.defaultPaymentMethodId`, `order.orderCustomer.customer`.`created_at` as `order.orderCustomer.customer.createdAt`, `order.orderCustomer.customer`.`updated_at` as `order.orderCustomer.customer.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.stateMachineState`.`id` as `order.stateMachineState.id`, `order.stateMachineState`.`technical_name` as `order.stateMachineState.technicalName`, `order.stateMachineState`.`state_machine_id` as `order.stateMachineState.stateMachineId`, `order.stateMachineState`.`created_at` as `order.stateMachineState.createdAt`, `order.stateMachineState`.`updated_at` as `order.stateMachineState.updatedAt`, `order.stateMachineState.translation.name`, `order.stateMachineState.translation.name` as `order.stateMachineState.name`, `order.stateMachineState.translation.customFields`, `order.stateMachineState.translation.customFields` as `order.stateMachineState.customFields`, `order.language`.`id` as `order.language.id`, `order.language`.`parent_id` as `order.language.parentId`, `order.language`.`locale_id` as `order.language.localeId`, `order.language`.`translation_code_id` as `order.language.translationCodeId`, `order.language`.`name` as `order.language.name`, `order.language`.`custom_fields` as `order.language.customFields`, `order.language`.`created_at` as `order.language.createdAt`, `order.language`.`updated_at` as `order.language.updatedAt`, `order.language.locale`.`id` as `order.language.locale.id`, `order.language.locale`.`code` as `order.language.locale.code`, `order.language.locale`.`created_at` as `order.language.locale.createdAt`, `order.language.locale`.`updated_at` as `order.language.locale.updatedAt`, `order.language.locale.translation.name`, `order.language.locale.translation.name` as `order.language.locale.name`, `order.language.locale.translation.territory`, `order.language.locale.translation.territory` as `order.language.locale.territory`, `order.language.locale.translation.customFields`, `order.language.locale.translation.customFields` as `order.language.locale.customFields`, `order.currency`.`id` as `order.currency.id`, `order.currency`.`factor` as `order.currency.factor`, `order.currency`.`symbol` as `order.currency.symbol`, `order.currency`.`iso_code` as `order.currency.isoCode`, `order.currency`.`position` as `order.currency.position`, `order.currency`.`tax_free_from` as `order.currency.taxFreeFrom`, `order.currency`.`item_rounding` as `order.currency.itemRounding`, `order.currency`.`total_rounding` as `order.currency.totalRounding`, `order.currency`.`created_at` as `order.currency.createdAt`, `order.currency`.`updated_at` as `order.currency.updatedAt`, `order.currency.translation.shortName`, `order.currency.translation.shortName` as `order.currency.shortName`, `order.currency.translation.name`, `order.currency.translation.name` as `order.currency.name`, `order.currency.translation.customFields`, `order.currency.translation.customFields` as `order.currency.customFields`, (SELECT GROUP_CONCAT(HEX(`order.tags.mapping`.`tag_id`) SEPARATOR '||')
                  FROM `order_tag` `order.tags.mapping`
                  WHERE `order.tags.mapping`.`order_id` = `order`.`id` ) as `order.tags.id_mapping` 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 `state_machine_state` `order.stateMachineState` ON `order`.`state_id` = `order.stateMachineState`.`id` LEFT JOIN `language` `order.language` ON `order`.`language_id` = `order.language`.`id` LEFT JOIN `currency` `order.currency` ON `order`.`currency_id` = `order.currency`.`id` LEFT JOIN `customer` `order.orderCustomer.customer` ON `order.orderCustomer`.`customer_id` = `order.orderCustomer.customer`.`id` LEFT JOIN (SELECT `order.stateMachineState.translation`.`state_machine_state_id`, `order.stateMachineState.translation`.`name` as `order.stateMachineState.translation.name`, `order.stateMachineState.translation`.`custom_fields` as `order.stateMachineState.translation.customFields` FROM `state_machine_state_translation` `order.stateMachineState.translation` WHERE `order.stateMachineState.translation`.`language_id` = ?) `order.stateMachineState.state_machine_state_translation` ON `order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order.stateMachineState`.`id` LEFT JOIN `locale` `order.language.locale` ON `order.language`.`locale_id` = `order.language.locale`.`id` LEFT JOIN (SELECT `order.language.locale.translation`.`locale_id`, `order.language.locale.translation`.`name` as `order.language.locale.translation.name`, `order.language.locale.translation`.`territory` as `order.language.locale.translation.territory`, `order.language.locale.translation`.`custom_fields` as `order.language.locale.translation.customFields` FROM `locale_translation` `order.language.locale.translation` WHERE `order.language.locale.translation`.`language_id` = ?) `order.language.locale.locale_translation` ON `order.language.locale.locale_translation`.`locale_id` = `order.language.locale`.`id` LEFT JOIN (SELECT `order.currency.translation`.`currency_id`, `order.currency.translation`.`short_name` as `order.currency.translation.shortName`, `order.currency.translation`.`name` as `order.currency.translation.name`, `order.currency.translation`.`custom_fields` as `order.currency.translation.customFields` FROM `currency_translation` `order.currency.translation` WHERE `order.currency.translation`.`language_id` = ?) `order.currency.currency_translation` ON `order.currency.currency_translation`.`currency_id` = `order.currency`.`id` WHERE (`order`.`version_id` = ?) AND (`order`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01“ô=ÎÌsW·þK€Ú½ìÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.84 ms
(10.90%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.41 ms
(9.25%) 		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`, `order_delivery.shippingOrderAddress`.`id` as `order_delivery.shippingOrderAddress.id`, `order_delivery.shippingOrderAddress`.`version_id` as `order_delivery.shippingOrderAddress.versionId`, `order_delivery.shippingOrderAddress`.`country_id` as `order_delivery.shippingOrderAddress.countryId`, `order_delivery.shippingOrderAddress`.`country_state_id` as `order_delivery.shippingOrderAddress.countryStateId`, `order_delivery.shippingOrderAddress`.`order_id` as `order_delivery.shippingOrderAddress.orderId`, `order_delivery.shippingOrderAddress`.`order_version_id` as `order_delivery.shippingOrderAddress.orderVersionId`, `order_delivery.shippingOrderAddress`.`salutation_id` as `order_delivery.shippingOrderAddress.salutationId`, `order_delivery.shippingOrderAddress`.`first_name` as `order_delivery.shippingOrderAddress.firstName`, `order_delivery.shippingOrderAddress`.`last_name` as `order_delivery.shippingOrderAddress.lastName`, `order_delivery.shippingOrderAddress`.`street` as `order_delivery.shippingOrderAddress.street`, `order_delivery.shippingOrderAddress`.`zipcode` as `order_delivery.shippingOrderAddress.zipcode`, `order_delivery.shippingOrderAddress`.`city` as `order_delivery.shippingOrderAddress.city`, `order_delivery.shippingOrderAddress`.`company` as `order_delivery.shippingOrderAddress.company`, `order_delivery.shippingOrderAddress`.`department` as `order_delivery.shippingOrderAddress.department`, `order_delivery.shippingOrderAddress`.`title` as `order_delivery.shippingOrderAddress.title`, `order_delivery.shippingOrderAddress`.`vat_id` as `order_delivery.shippingOrderAddress.vatId`, `order_delivery.shippingOrderAddress`.`phone_number` as `order_delivery.shippingOrderAddress.phoneNumber`, `order_delivery.shippingOrderAddress`.`additional_address_line1` as `order_delivery.shippingOrderAddress.additionalAddressLine1`, `order_delivery.shippingOrderAddress`.`additional_address_line2` as `order_delivery.shippingOrderAddress.additionalAddressLine2`, `order_delivery.shippingOrderAddress`.`custom_fields` as `order_delivery.shippingOrderAddress.customFields`, `order_delivery.shippingOrderAddress`.`created_at` as `order_delivery.shippingOrderAddress.createdAt`, `order_delivery.shippingOrderAddress`.`updated_at` as `order_delivery.shippingOrderAddress.updatedAt`, `order_delivery.shippingOrderAddress.salutation`.`id` as `order_delivery.shippingOrderAddress.salutation.id`, `order_delivery.shippingOrderAddress.salutation`.`salutation_key` as `order_delivery.shippingOrderAddress.salutation.salutationKey`, `order_delivery.shippingOrderAddress.salutation`.`created_at` as `order_delivery.shippingOrderAddress.salutation.createdAt`, `order_delivery.shippingOrderAddress.salutation`.`updated_at` as `order_delivery.shippingOrderAddress.salutation.updatedAt`, `order_delivery.shippingOrderAddress.salutation.translation.displayName`, `order_delivery.shippingOrderAddress.salutation.translation.displayName` as `order_delivery.shippingOrderAddress.salutation.displayName`, `order_delivery.shippingOrderAddress.salutation.translation.letterName`, `order_delivery.shippingOrderAddress.salutation.translation.letterName` as `order_delivery.shippingOrderAddress.salutation.letterName`, `order_delivery.shippingOrderAddress.salutation.translation.customFields`, `order_delivery.shippingOrderAddress.salutation.translation.customFields` as `order_delivery.shippingOrderAddress.salutation.customFields`, `order_delivery.shippingOrderAddress.country`.`id` as `order_delivery.shippingOrderAddress.country.id`, `order_delivery.shippingOrderAddress.country`.`iso` as `order_delivery.shippingOrderAddress.country.iso`, `order_delivery.shippingOrderAddress.country`.`position` as `order_delivery.shippingOrderAddress.country.position`, `order_delivery.shippingOrderAddress.country`.`active` as `order_delivery.shippingOrderAddress.country.active`, `order_delivery.shippingOrderAddress.country`.`shipping_available` as `order_delivery.shippingOrderAddress.country.shippingAvailable`, `order_delivery.shippingOrderAddress.country`.`iso3` as `order_delivery.shippingOrderAddress.country.iso3`, `order_delivery.shippingOrderAddress.country`.`display_state_in_registration` as `order_delivery.shippingOrderAddress.country.displayStateInRegistration`, `order_delivery.shippingOrderAddress.country`.`force_state_in_registration` as `order_delivery.shippingOrderAddress.country.forceStateInRegistration`, `order_delivery.shippingOrderAddress.country`.`check_vat_id_pattern` as `order_delivery.shippingOrderAddress.country.checkVatIdPattern`, `order_delivery.shippingOrderAddress.country`.`vat_id_required` as `order_delivery.shippingOrderAddress.country.vatIdRequired`, `order_delivery.shippingOrderAddress.country`.`vat_id_pattern` as `order_delivery.shippingOrderAddress.country.vatIdPattern`, `order_delivery.shippingOrderAddress.country`.`customer_tax` as `order_delivery.shippingOrderAddress.country.customerTax`, `order_delivery.shippingOrderAddress.country`.`company_tax` as `order_delivery.shippingOrderAddress.country.companyTax`, `order_delivery.shippingOrderAddress.country`.`postal_code_required` as `order_delivery.shippingOrderAddress.country.postalCodeRequired`, `order_delivery.shippingOrderAddress.country`.`check_postal_code_pattern` as `order_delivery.shippingOrderAddress.country.checkPostalCodePattern`, `order_delivery.shippingOrderAddress.country`.`check_advanced_postal_code_pattern` as `order_delivery.shippingOrderAddress.country.checkAdvancedPostalCodePattern`, `order_delivery.shippingOrderAddress.country`.`advanced_postal_code_pattern` as `order_delivery.shippingOrderAddress.country.advancedPostalCodePattern`, `order_delivery.shippingOrderAddress.country`.`default_postal_code_pattern` as `order_delivery.shippingOrderAddress.country.defaultPostalCodePattern`, `order_delivery.shippingOrderAddress.country`.`is_eu` as `order_delivery.shippingOrderAddress.country.isEu`, `order_delivery.shippingOrderAddress.country`.`created_at` as `order_delivery.shippingOrderAddress.country.createdAt`, `order_delivery.shippingOrderAddress.country`.`updated_at` as `order_delivery.shippingOrderAddress.country.updatedAt`, `order_delivery.shippingOrderAddress.country.translation.name`, `order_delivery.shippingOrderAddress.country.translation.name` as `order_delivery.shippingOrderAddress.country.name`, `order_delivery.shippingOrderAddress.country.translation.addressFormat`, `order_delivery.shippingOrderAddress.country.translation.addressFormat` as `order_delivery.shippingOrderAddress.country.addressFormat`, `order_delivery.shippingOrderAddress.country.translation.customFields`, `order_delivery.shippingOrderAddress.country.translation.customFields` as `order_delivery.shippingOrderAddress.country.customFields`, `order_delivery.shippingMethod`.`id` as `order_delivery.shippingMethod.id`, `order_delivery.shippingMethod`.`active` as `order_delivery.shippingMethod.active`, `order_delivery.shippingMethod`.`position` as `order_delivery.shippingMethod.position`, `order_delivery.shippingMethod`.`availability_rule_id` as `order_delivery.shippingMethod.availabilityRuleId`, `order_delivery.shippingMethod`.`media_id` as `order_delivery.shippingMethod.mediaId`, `order_delivery.shippingMethod`.`delivery_time_id` as `order_delivery.shippingMethod.deliveryTimeId`, `order_delivery.shippingMethod`.`tax_type` as `order_delivery.shippingMethod.taxType`, `order_delivery.shippingMethod`.`tax_id` as `order_delivery.shippingMethod.taxId`, `order_delivery.shippingMethod.deliveryTime`.`id` as `order_delivery.shippingMethod.deliveryTime.id`, `order_delivery.shippingMethod.deliveryTime`.`min` as `order_delivery.shippingMethod.deliveryTime.min`, `order_delivery.shippingMethod.deliveryTime`.`max` as `order_delivery.shippingMethod.deliveryTime.max`, `order_delivery.shippingMethod.deliveryTime`.`unit` as `order_delivery.shippingMethod.deliveryTime.unit`, `order_delivery.shippingMethod.deliveryTime`.`created_at` as `order_delivery.shippingMethod.deliveryTime.createdAt`, `order_delivery.shippingMethod.deliveryTime`.`updated_at` as `order_delivery.shippingMethod.deliveryTime.updatedAt`, `order_delivery.shippingMethod.deliveryTime.translation.name`, `order_delivery.shippingMethod.deliveryTime.translation.name` as `order_delivery.shippingMethod.deliveryTime.name`, `order_delivery.shippingMethod.deliveryTime.translation.customFields`, `order_delivery.shippingMethod.deliveryTime.translation.customFields` as `order_delivery.shippingMethod.deliveryTime.customFields`, `order_delivery.shippingMethod.appShippingMethod`.`id` as `order_delivery.shippingMethod.appShippingMethod.id`, `order_delivery.shippingMethod.appShippingMethod`.`app_name` as `order_delivery.shippingMethod.appShippingMethod.appName`, `order_delivery.shippingMethod.appShippingMethod`.`identifier` as `order_delivery.shippingMethod.appShippingMethod.identifier`, `order_delivery.shippingMethod.appShippingMethod`.`app_id` as `order_delivery.shippingMethod.appShippingMethod.appId`, `order_delivery.shippingMethod.appShippingMethod`.`shipping_method_id` as `order_delivery.shippingMethod.appShippingMethod.shippingMethodId`, `order_delivery.shippingMethod.appShippingMethod`.`original_media_id` as `order_delivery.shippingMethod.appShippingMethod.originalMediaId`, `order_delivery.shippingMethod.appShippingMethod`.`created_at` as `order_delivery.shippingMethod.appShippingMethod.createdAt`, `order_delivery.shippingMethod.appShippingMethod`.`updated_at` as `order_delivery.shippingMethod.appShippingMethod.updatedAt`, `order_delivery.shippingMethod`.`technical_name` as `order_delivery.shippingMethod.technicalName`, `order_delivery.shippingMethod`.`created_at` as `order_delivery.shippingMethod.createdAt`, `order_delivery.shippingMethod`.`updated_at` as `order_delivery.shippingMethod.updatedAt`, `order_delivery.shippingMethod.translation.name`, `order_delivery.shippingMethod.translation.name` as `order_delivery.shippingMethod.name`, `order_delivery.shippingMethod.translation.description`, `order_delivery.shippingMethod.translation.description` as `order_delivery.shippingMethod.description`, `order_delivery.shippingMethod.translation.trackingUrl`, `order_delivery.shippingMethod.translation.trackingUrl` as `order_delivery.shippingMethod.trackingUrl`, `order_delivery.shippingMethod.translation.customFields`, `order_delivery.shippingMethod.translation.customFields` as `order_delivery.shippingMethod.customFields`, `order_delivery.stateMachineState`.`id` as `order_delivery.stateMachineState.id`, `order_delivery.stateMachineState`.`technical_name` as `order_delivery.stateMachineState.technicalName`, `order_delivery.stateMachineState`.`state_machine_id` as `order_delivery.stateMachineState.stateMachineId`, `order_delivery.stateMachineState`.`created_at` as `order_delivery.stateMachineState.createdAt`, `order_delivery.stateMachineState`.`updated_at` as `order_delivery.stateMachineState.updatedAt`, `order_delivery.stateMachineState.translation.name`, `order_delivery.stateMachineState.translation.name` as `order_delivery.stateMachineState.name`, `order_delivery.stateMachineState.translation.customFields`, `order_delivery.stateMachineState.translation.customFields` as `order_delivery.stateMachineState.customFields` FROM `order_delivery` LEFT JOIN `order_address` `order_delivery.shippingOrderAddress` ON `order_delivery`.`shipping_order_address_id` = `order_delivery.shippingOrderAddress`.`id` AND `order_delivery`.`shipping_order_address_version_id` = `order_delivery.shippingOrderAddress`.`version_id` LEFT JOIN `shipping_method` `order_delivery.shippingMethod` ON `order_delivery`.`shipping_method_id` = `order_delivery.shippingMethod`.`id` LEFT JOIN `state_machine_state` `order_delivery.stateMachineState` ON `order_delivery`.`state_id` = `order_delivery.stateMachineState`.`id` LEFT JOIN `salutation` `order_delivery.shippingOrderAddress.salutation` ON `order_delivery.shippingOrderAddress`.`salutation_id` = `order_delivery.shippingOrderAddress.salutation`.`id` LEFT JOIN `country` `order_delivery.shippingOrderAddress.country` ON `order_delivery.shippingOrderAddress`.`country_id` = `order_delivery.shippingOrderAddress.country`.`id` LEFT JOIN (SELECT `order_delivery.shippingOrderAddress.salutation.translation`.`salutation_id`, `order_delivery.shippingOrderAddress.salutation.translation`.`display_name` as `order_delivery.shippingOrderAddress.salutation.translation.displayName`, `order_delivery.shippingOrderAddress.salutation.translation`.`letter_name` as `order_delivery.shippingOrderAddress.salutation.translation.letterName`, `order_delivery.shippingOrderAddress.salutation.translation`.`custom_fields` as `order_delivery.shippingOrderAddress.salutation.translation.customFields` FROM `salutation_translation` `order_delivery.shippingOrderAddress.salutation.translation` WHERE `order_delivery.shippingOrderAddress.salutation.translation`.`language_id` = ?) `order_delivery.shippingOrderAddress.salutation.salutation_translation` ON `order_delivery.shippingOrderAddress.salutation.salutation_translation`.`salutation_id` = `order_delivery.shippingOrderAddress.salutation`.`id` LEFT JOIN (SELECT `order_delivery.shippingOrderAddress.country.translation`.`country_id`, `order_delivery.shippingOrderAddress.country.translation`.`name` as `order_delivery.shippingOrderAddress.country.translation.name`, `order_delivery.shippingOrderAddress.country.translation`.`custom_fields` as `order_delivery.shippingOrderAddress.country.translation.customFields`, `order_delivery.shippingOrderAddress.country.translation`.`address_format` as `order_delivery.shippingOrderAddress.country.translation.addressFormat` FROM `country_translation` `order_delivery.shippingOrderAddress.country.translation` WHERE `order_delivery.shippingOrderAddress.country.translation`.`language_id` = ?) `order_delivery.shippingOrderAddress.country.country_translation` ON `order_delivery.shippingOrderAddress.country.country_translation`.`country_id` = `order_delivery.shippingOrderAddress.country`.`id` LEFT JOIN `delivery_time` `order_delivery.shippingMethod.deliveryTime` ON `order_delivery.shippingMethod`.`delivery_time_id` = `order_delivery.shippingMethod.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `order_delivery.shippingMethod.appShippingMethod` ON `order_delivery.shippingMethod`.`id` = `order_delivery.shippingMethod.appShippingMethod`.`shipping_method_id` LEFT JOIN (SELECT `order_delivery.shippingMethod.translation`.`shipping_method_id`, `order_delivery.shippingMethod.translation`.`name` as `order_delivery.shippingMethod.translation.name`, `order_delivery.shippingMethod.translation`.`custom_fields` as `order_delivery.shippingMethod.translation.customFields`, `order_delivery.shippingMethod.translation`.`description` as `order_delivery.shippingMethod.translation.description`, `order_delivery.shippingMethod.translation`.`tracking_url` as `order_delivery.shippingMethod.translation.trackingUrl` FROM `shipping_method_translation` `order_delivery.shippingMethod.translation` WHERE `order_delivery.shippingMethod.translation`.`language_id` = ?) `order_delivery.shippingMethod.shipping_method_translation` ON `order_delivery.shippingMethod.shipping_method_translation`.`shipping_method_id` = `order_delivery.shippingMethod`.`id` LEFT JOIN (SELECT `order_delivery.shippingMethod.deliveryTime.translation`.`delivery_time_id`, `order_delivery.shippingMethod.deliveryTime.translation`.`name` as `order_delivery.shippingMethod.deliveryTime.translation.name`, `order_delivery.shippingMethod.deliveryTime.translation`.`custom_fields` as `order_delivery.shippingMethod.deliveryTime.translation.customFields` FROM `delivery_time_translation` `order_delivery.shippingMethod.deliveryTime.translation` WHERE `order_delivery.shippingMethod.deliveryTime.translation`.`language_id` = ?) `order_delivery.shippingMethod.deliveryTime.delivery_time_translation` ON `order_delivery.shippingMethod.deliveryTime.delivery_time_translation`.`delivery_time_id` = `order_delivery.shippingMethod.deliveryTime`.`id` LEFT JOIN (SELECT `order_delivery.stateMachineState.translation`.`state_machine_state_id`, `order_delivery.stateMachineState.translation`.`name` as `order_delivery.stateMachineState.translation.name`, `order_delivery.stateMachineState.translation`.`custom_fields` as `order_delivery.stateMachineState.translation.customFields` FROM `state_machine_state_translation` `order_delivery.stateMachineState.translation` WHERE `order_delivery.stateMachineState.translation`.`language_id` = ?) `order_delivery.stateMachineState.state_machine_state_translation` ON `order_delivery.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_delivery.stateMachineState`.`id` WHERE (`order_delivery`.`version_id` = ?) AND ((`order_delivery`.`order_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01“ô=ÎÌsW·þK€Ú½ìÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.79 ms
(6.87%) 		1 
SELECT `order_address`.`id` as `order_address.id`, `order_address`.`version_id` as `order_address.versionId`, `order_address`.`country_id` as `order_address.countryId`, `order_address`.`country_state_id` as `order_address.countryStateId`, `order_address`.`order_id` as `order_address.orderId`, `order_address`.`order_version_id` as `order_address.orderVersionId`, `order_address`.`salutation_id` as `order_address.salutationId`, `order_address`.`first_name` as `order_address.firstName`, `order_address`.`last_name` as `order_address.lastName`, `order_address`.`street` as `order_address.street`, `order_address`.`zipcode` as `order_address.zipcode`, `order_address`.`city` as `order_address.city`, `order_address`.`company` as `order_address.company`, `order_address`.`department` as `order_address.department`, `order_address`.`title` as `order_address.title`, `order_address`.`vat_id` as `order_address.vatId`, `order_address`.`phone_number` as `order_address.phoneNumber`, `order_address`.`additional_address_line1` as `order_address.additionalAddressLine1`, `order_address`.`additional_address_line2` as `order_address.additionalAddressLine2`, `order_address`.`custom_fields` as `order_address.customFields`, `order_address`.`created_at` as `order_address.createdAt`, `order_address`.`updated_at` as `order_address.updatedAt`, `order_address.salutation`.`id` as `order_address.salutation.id`, `order_address.salutation`.`salutation_key` as `order_address.salutation.salutationKey`, `order_address.salutation`.`created_at` as `order_address.salutation.createdAt`, `order_address.salutation`.`updated_at` as `order_address.salutation.updatedAt`, `order_address.salutation.translation.displayName`, `order_address.salutation.translation.displayName` as `order_address.salutation.displayName`, `order_address.salutation.translation.letterName`, `order_address.salutation.translation.letterName` as `order_address.salutation.letterName`, `order_address.salutation.translation.customFields`, `order_address.salutation.translation.customFields` as `order_address.salutation.customFields`, `order_address.country`.`id` as `order_address.country.id`, `order_address.country`.`iso` as `order_address.country.iso`, `order_address.country`.`position` as `order_address.country.position`, `order_address.country`.`active` as `order_address.country.active`, `order_address.country`.`shipping_available` as `order_address.country.shippingAvailable`, `order_address.country`.`iso3` as `order_address.country.iso3`, `order_address.country`.`display_state_in_registration` as `order_address.country.displayStateInRegistration`, `order_address.country`.`force_state_in_registration` as `order_address.country.forceStateInRegistration`, `order_address.country`.`check_vat_id_pattern` as `order_address.country.checkVatIdPattern`, `order_address.country`.`vat_id_required` as `order_address.country.vatIdRequired`, `order_address.country`.`vat_id_pattern` as `order_address.country.vatIdPattern`, `order_address.country`.`customer_tax` as `order_address.country.customerTax`, `order_address.country`.`company_tax` as `order_address.country.companyTax`, `order_address.country`.`postal_code_required` as `order_address.country.postalCodeRequired`, `order_address.country`.`check_postal_code_pattern` as `order_address.country.checkPostalCodePattern`, `order_address.country`.`check_advanced_postal_code_pattern` as `order_address.country.checkAdvancedPostalCodePattern`, `order_address.country`.`advanced_postal_code_pattern` as `order_address.country.advancedPostalCodePattern`, `order_address.country`.`default_postal_code_pattern` as `order_address.country.defaultPostalCodePattern`, `order_address.country`.`is_eu` as `order_address.country.isEu`, `order_address.country`.`created_at` as `order_address.country.createdAt`, `order_address.country`.`updated_at` as `order_address.country.updatedAt`, `order_address.country.translation.name`, `order_address.country.translation.name` as `order_address.country.name`, `order_address.country.translation.addressFormat`, `order_address.country.translation.addressFormat` as `order_address.country.addressFormat`, `order_address.country.translation.customFields`, `order_address.country.translation.customFields` as `order_address.country.customFields`, `order_address.countryState`.`id` as `order_address.countryState.id`, `order_address.countryState`.`country_id` as `order_address.countryState.countryId`, `order_address.countryState`.`short_code` as `order_address.countryState.shortCode`, `order_address.countryState`.`position` as `order_address.countryState.position`, `order_address.countryState`.`active` as `order_address.countryState.active`, `order_address.countryState`.`created_at` as `order_address.countryState.createdAt`, `order_address.countryState`.`updated_at` as `order_address.countryState.updatedAt`, `order_address.countryState.translation.name`, `order_address.countryState.translation.name` as `order_address.countryState.name`, `order_address.countryState.translation.customFields`, `order_address.countryState.translation.customFields` as `order_address.countryState.customFields` FROM `order_address` LEFT JOIN `salutation` `order_address.salutation` ON `order_address`.`salutation_id` = `order_address.salutation`.`id` LEFT JOIN `country` `order_address.country` ON `order_address`.`country_id` = `order_address.country`.`id` LEFT JOIN `country_state` `order_address.countryState` ON `order_address`.`country_state_id` = `order_address.countryState`.`id` LEFT JOIN (SELECT `order_address.salutation.translation`.`salutation_id`, `order_address.salutation.translation`.`display_name` as `order_address.salutation.translation.displayName`, `order_address.salutation.translation`.`letter_name` as `order_address.salutation.translation.letterName`, `order_address.salutation.translation`.`custom_fields` as `order_address.salutation.translation.customFields` FROM `salutation_translation` `order_address.salutation.translation` WHERE `order_address.salutation.translation`.`language_id` = ?) `order_address.salutation.salutation_translation` ON `order_address.salutation.salutation_translation`.`salutation_id` = `order_address.salutation`.`id` LEFT JOIN (SELECT `order_address.country.translation`.`country_id`, `order_address.country.translation`.`name` as `order_address.country.translation.name`, `order_address.country.translation`.`custom_fields` as `order_address.country.translation.customFields`, `order_address.country.translation`.`address_format` as `order_address.country.translation.addressFormat` FROM `country_translation` `order_address.country.translation` WHERE `order_address.country.translation`.`language_id` = ?) `order_address.country.country_translation` ON `order_address.country.country_translation`.`country_id` = `order_address.country`.`id` LEFT JOIN (SELECT `order_address.countryState.translation`.`country_state_id`, `order_address.countryState.translation`.`name` as `order_address.countryState.translation.name`, `order_address.countryState.translation`.`custom_fields` as `order_address.countryState.translation.customFields` FROM `country_state_translation` `order_address.countryState.translation` WHERE `order_address.countryState.translation`.`language_id` = ?) `order_address.countryState.country_state_translation` ON `order_address.countryState.country_state_translation`.`country_state_id` = `order_address.countryState`.`id` WHERE (`order_address`.`version_id` = ?) AND ((`order_address`.`order_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01“ô=ÎÌsW·þK€Ú½ìÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.75 ms
(6.72%) 		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.paymentMethod`.`id` as `order_transaction.paymentMethod.id`, `order_transaction.paymentMethod`.`plugin_id` as `order_transaction.paymentMethod.pluginId`, `order_transaction.paymentMethod`.`handler_identifier` as `order_transaction.paymentMethod.handlerIdentifier`, `order_transaction.paymentMethod`.`position` as `order_transaction.paymentMethod.position`, `order_transaction.paymentMethod`.`active` as `order_transaction.paymentMethod.active`, `order_transaction.paymentMethod`.`after_order_enabled` as `order_transaction.paymentMethod.afterOrderEnabled`, `order_transaction.paymentMethod`.`availability_rule_id` as `order_transaction.paymentMethod.availabilityRuleId`, `order_transaction.paymentMethod`.`media_id` as `order_transaction.paymentMethod.mediaId`, `order_transaction.paymentMethod.appPaymentMethod`.`id` as `order_transaction.paymentMethod.appPaymentMethod.id`, `order_transaction.paymentMethod.appPaymentMethod`.`app_name` as `order_transaction.paymentMethod.appPaymentMethod.appName`, `order_transaction.paymentMethod.appPaymentMethod`.`identifier` as `order_transaction.paymentMethod.appPaymentMethod.identifier`, `order_transaction.paymentMethod.appPaymentMethod`.`pay_url` as `order_transaction.paymentMethod.appPaymentMethod.payUrl`, `order_transaction.paymentMethod.appPaymentMethod`.`finalize_url` as `order_transaction.paymentMethod.appPaymentMethod.finalizeUrl`, `order_transaction.paymentMethod.appPaymentMethod`.`validate_url` as `order_transaction.paymentMethod.appPaymentMethod.validateUrl`, `order_transaction.paymentMethod.appPaymentMethod`.`capture_url` as `order_transaction.paymentMethod.appPaymentMethod.captureUrl`, `order_transaction.paymentMethod.appPaymentMethod`.`refund_url` as `order_transaction.paymentMethod.appPaymentMethod.refundUrl`, `order_transaction.paymentMethod.appPaymentMethod`.`recurring_url` as `order_transaction.paymentMethod.appPaymentMethod.recurringUrl`, `order_transaction.paymentMethod.appPaymentMethod`.`app_id` as `order_transaction.paymentMethod.appPaymentMethod.appId`, `order_transaction.paymentMethod.appPaymentMethod`.`original_media_id` as `order_transaction.paymentMethod.appPaymentMethod.originalMediaId`, `order_transaction.paymentMethod.appPaymentMethod`.`payment_method_id` as `order_transaction.paymentMethod.appPaymentMethod.paymentMethodId`, `order_transaction.paymentMethod.appPaymentMethod`.`created_at` as `order_transaction.paymentMethod.appPaymentMethod.createdAt`, `order_transaction.paymentMethod.appPaymentMethod`.`updated_at` as `order_transaction.paymentMethod.appPaymentMethod.updatedAt`, `order_transaction.paymentMethod`.`technical_name` as `order_transaction.paymentMethod.technicalName`, `order_transaction.paymentMethod`.`created_at` as `order_transaction.paymentMethod.createdAt`, `order_transaction.paymentMethod`.`updated_at` as `order_transaction.paymentMethod.updatedAt`, `order_transaction.paymentMethod.translation.name`, `order_transaction.paymentMethod.translation.name` as `order_transaction.paymentMethod.name`, `order_transaction.paymentMethod.translation.distinguishableName`, `order_transaction.paymentMethod.translation.distinguishableName` as `order_transaction.paymentMethod.distinguishableName`, `order_transaction.paymentMethod.translation.description`, `order_transaction.paymentMethod.translation.description` as `order_transaction.paymentMethod.description`, `order_transaction.paymentMethod.translation.customFields`, `order_transaction.paymentMethod.translation.customFields` as `order_transaction.paymentMethod.customFields` FROM `order_transaction` LEFT JOIN `payment_method` `order_transaction.paymentMethod` ON `order_transaction`.`payment_method_id` = `order_transaction.paymentMethod`.`id` LEFT JOIN `app_payment_method` `order_transaction.paymentMethod.appPaymentMethod` ON `order_transaction.paymentMethod`.`id` = `order_transaction.paymentMethod.appPaymentMethod`.`payment_method_id` LEFT JOIN (SELECT `order_transaction.paymentMethod.translation`.`payment_method_id`, `order_transaction.paymentMethod.translation`.`name` as `order_transaction.paymentMethod.translation.name`, `order_transaction.paymentMethod.translation`.`distinguishable_name` as `order_transaction.paymentMethod.translation.distinguishableName`, `order_transaction.paymentMethod.translation`.`description` as `order_transaction.paymentMethod.translation.description`, `order_transaction.paymentMethod.translation`.`custom_fields` as `order_transaction.paymentMethod.translation.customFields` FROM `payment_method_translation` `order_transaction.paymentMethod.translation` WHERE `order_transaction.paymentMethod.translation`.`language_id` = ?) `order_transaction.paymentMethod.payment_method_translation` ON `order_transaction.paymentMethod.payment_method_translation`.`payment_method_id` = `order_transaction.paymentMethod`.`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“ô=ÎÌsW·þK€Ú½ìÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.61 ms
(6.20%) 		2 
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`from_state_id` IN (?))
Parameters: 
[
  b"\x01’µ8j p­ºhê«„0wI"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(3.98%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(3.98%) 		1 
SELECT `order`.`id`, `order`.`auto_increment`, `order`.`order_number` FROM `order` WHERE (`order`.`version_id` = ?) AND (((`order`.`created_at` >= ?))) ORDER BY `order`.`created_at` ASC, `order`.`id` ASC LIMIT 50
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "2024-12-23T15:58:31"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(3.23%) 		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.74 ms
(2.85%) 		1 
SELECT COUNT(*) FROM (SELECT `order`.`id`, `order`.`auto_increment`, `order`.`order_number` FROM `order` WHERE (`order`.`version_id` = ?) AND (((`order`.`created_at` >= ?)))) total
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "2024-12-23T15:58:31"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(2.61%) 		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.68 ms
(2.60%) 		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.64 ms
(2.46%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.86%) 		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"\x01Æ©ì\x10c{å¡Ñ╝ÚNÂPù"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(1.79%) 		1 
SELECT id FROM integration WHERE access_key = ?
Parameters: 
[
  "SWIAYURKWGSZZHZODW1KEXRIQW"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(1.52%) 		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"\x01Æ©ì\x10c{å¡Ñ╝ÚNÂPù"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(1.45%) 		1 
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',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(1.03%) 		1 
SELECT admin FROM `integration` WHERE id = ?
Parameters: 
[
  b"\x01Æ©ì\x10c{å¡Ñ╝ÚNÂPù"
]
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.