GET https://eu.verinice.shop/api/verinice/esd

Response
200 OK
IP
2a0a:a3c0:0:d2ee::1
Profiled on
Token
1f81f8

Query Metrics

20 Database Queries
19 Different statements
4.91 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
0.90 ms
(18.42%) 		1 
SELECT `sas_product_esd_order`.`id` as `sas_product_esd_order.id`, `sas_product_esd_order`.`esd_id` as `sas_product_esd_order.esdId`, `sas_product_esd_order`.`order_line_item_id` as `sas_product_esd_order.orderLineItemId`, `sas_product_esd_order`.`serial_id` as `sas_product_esd_order.serialId`, `sas_product_esd_order`.`count_download` as `sas_product_esd_order.countDownload`, `sas_product_esd_order`.`created_at` as `sas_product_esd_order.createdAt`, `sas_product_esd_order`.`updated_at` as `sas_product_esd_order.updatedAt`, `sas_product_esd_order.orderLineItem`.`id` as `sas_product_esd_order.orderLineItem.id`, `sas_product_esd_order.orderLineItem`.`version_id` as `sas_product_esd_order.orderLineItem.versionId`, `sas_product_esd_order.orderLineItem`.`order_id` as `sas_product_esd_order.orderLineItem.orderId`, `sas_product_esd_order.orderLineItem`.`order_version_id` as `sas_product_esd_order.orderLineItem.orderVersionId`, `sas_product_esd_order.orderLineItem`.`product_id` as `sas_product_esd_order.orderLineItem.productId`, `sas_product_esd_order.orderLineItem`.`product_version_id` as `sas_product_esd_order.orderLineItem.productVersionId`, `sas_product_esd_order.orderLineItem`.`promotion_id` as `sas_product_esd_order.orderLineItem.promotionId`, `sas_product_esd_order.orderLineItem`.`parent_id` as `sas_product_esd_order.orderLineItem.parentId`, `sas_product_esd_order.orderLineItem`.`parent_version_id` as `sas_product_esd_order.orderLineItem.parentVersionId`, `sas_product_esd_order.orderLineItem`.`cover_id` as `sas_product_esd_order.orderLineItem.coverId`, `sas_product_esd_order.orderLineItem`.`identifier` as `sas_product_esd_order.orderLineItem.identifier`, `sas_product_esd_order.orderLineItem`.`referenced_id` as `sas_product_esd_order.orderLineItem.referencedId`, `sas_product_esd_order.orderLineItem`.`quantity` as `sas_product_esd_order.orderLineItem.quantity`, `sas_product_esd_order.orderLineItem`.`label` as `sas_product_esd_order.orderLineItem.label`, `sas_product_esd_order.orderLineItem`.`payload` as `sas_product_esd_order.orderLineItem.payload`, `sas_product_esd_order.orderLineItem`.`good` as `sas_product_esd_order.orderLineItem.good`, `sas_product_esd_order.orderLineItem`.`removable` as `sas_product_esd_order.orderLineItem.removable`, `sas_product_esd_order.orderLineItem`.`stackable` as `sas_product_esd_order.orderLineItem.stackable`, `sas_product_esd_order.orderLineItem`.`position` as `sas_product_esd_order.orderLineItem.position`, `sas_product_esd_order.orderLineItem`.`states` as `sas_product_esd_order.orderLineItem.states`, `sas_product_esd_order.orderLineItem`.`price` as `sas_product_esd_order.orderLineItem.price`, `sas_product_esd_order.orderLineItem`.`price_definition` as `sas_product_esd_order.orderLineItem.priceDefinition`, `sas_product_esd_order.orderLineItem`.`unit_price` as `sas_product_esd_order.orderLineItem.unitPrice`, `sas_product_esd_order.orderLineItem`.`total_price` as `sas_product_esd_order.orderLineItem.totalPrice`, `sas_product_esd_order.orderLineItem`.`description` as `sas_product_esd_order.orderLineItem.description`, `sas_product_esd_order.orderLineItem`.`type` as `sas_product_esd_order.orderLineItem.type`, `sas_product_esd_order.orderLineItem`.`custom_fields` as `sas_product_esd_order.orderLineItem.customFields`, `sas_product_esd_order.orderLineItem`.`created_at` as `sas_product_esd_order.orderLineItem.createdAt`, `sas_product_esd_order.orderLineItem`.`updated_at` as `sas_product_esd_order.orderLineItem.updatedAt`, `sas_product_esd_order.orderLineItem.order`.`id` as `sas_product_esd_order.orderLineItem.order.id`, `sas_product_esd_order.orderLineItem.order`.`version_id` as `sas_product_esd_order.orderLineItem.order.versionId`, `sas_product_esd_order.orderLineItem.order`.`auto_increment` as `sas_product_esd_order.orderLineItem.order.autoIncrement`, `sas_product_esd_order.orderLineItem.order`.`order_number` as `sas_product_esd_order.orderLineItem.order.orderNumber`, `sas_product_esd_order.orderLineItem.order`.`billing_address_id` as `sas_product_esd_order.orderLineItem.order.billingAddressId`, `sas_product_esd_order.orderLineItem.order`.`billing_address_version_id` as `sas_product_esd_order.orderLineItem.order.billingAddressVersionId`, `sas_product_esd_order.orderLineItem.order`.`currency_id` as `sas_product_esd_order.orderLineItem.order.currencyId`, `sas_product_esd_order.orderLineItem.order`.`language_id` as `sas_product_esd_order.orderLineItem.order.languageId`, `sas_product_esd_order.orderLineItem.order`.`sales_channel_id` as `sas_product_esd_order.orderLineItem.order.salesChannelId`, `sas_product_esd_order.orderLineItem.order`.`order_date_time` as `sas_product_esd_order.orderLineItem.order.orderDateTime`, `sas_product_esd_order.orderLineItem.order`.`order_date` as `sas_product_esd_order.orderLineItem.order.orderDate`, `sas_product_esd_order.orderLineItem.order`.`price` as `sas_product_esd_order.orderLineItem.order.price`, `sas_product_esd_order.orderLineItem.order`.`amount_total` as `sas_product_esd_order.orderLineItem.order.amountTotal`, `sas_product_esd_order.orderLineItem.order`.`amount_net` as `sas_product_esd_order.orderLineItem.order.amountNet`, `sas_product_esd_order.orderLineItem.order`.`position_price` as `sas_product_esd_order.orderLineItem.order.positionPrice`, `sas_product_esd_order.orderLineItem.order`.`tax_status` as `sas_product_esd_order.orderLineItem.order.taxStatus`, `sas_product_esd_order.orderLineItem.order`.`shipping_costs` as `sas_product_esd_order.orderLineItem.order.shippingCosts`, `sas_product_esd_order.orderLineItem.order`.`shipping_total` as `sas_product_esd_order.orderLineItem.order.shippingTotal`, `sas_product_esd_order.orderLineItem.order`.`currency_factor` as `sas_product_esd_order.orderLineItem.order.currencyFactor`, `sas_product_esd_order.orderLineItem.order`.`deep_link_code` as `sas_product_esd_order.orderLineItem.order.deepLinkCode`, `sas_product_esd_order.orderLineItem.order`.`affiliate_code` as `sas_product_esd_order.orderLineItem.order.affiliateCode`, `sas_product_esd_order.orderLineItem.order`.`campaign_code` as `sas_product_esd_order.orderLineItem.order.campaignCode`, `sas_product_esd_order.orderLineItem.order`.`customer_comment` as `sas_product_esd_order.orderLineItem.order.customerComment`, `sas_product_esd_order.orderLineItem.order`.`source` as `sas_product_esd_order.orderLineItem.order.source`, `sas_product_esd_order.orderLineItem.order`.`tax_calculation_type` as `sas_product_esd_order.orderLineItem.order.taxCalculationType`, `sas_product_esd_order.orderLineItem.order`.`state_id` as `sas_product_esd_order.orderLineItem.order.stateId`, `sas_product_esd_order.orderLineItem.order`.`rule_ids` as `sas_product_esd_order.orderLineItem.order.ruleIds`, `sas_product_esd_order.orderLineItem.order`.`custom_fields` as `sas_product_esd_order.orderLineItem.order.customFields`, `sas_product_esd_order.orderLineItem.order`.`created_by_id` as `sas_product_esd_order.orderLineItem.order.createdById`, `sas_product_esd_order.orderLineItem.order`.`updated_by_id` as `sas_product_esd_order.orderLineItem.order.updatedById`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`id` as `sas_product_esd_order.orderLineItem.order.orderCustomer.id`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`version_id` as `sas_product_esd_order.orderLineItem.order.orderCustomer.versionId`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`customer_id` as `sas_product_esd_order.orderLineItem.order.orderCustomer.customerId`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`order_id` as `sas_product_esd_order.orderLineItem.order.orderCustomer.orderId`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`order_version_id` as `sas_product_esd_order.orderLineItem.order.orderCustomer.orderVersionId`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`email` as `sas_product_esd_order.orderLineItem.order.orderCustomer.email`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`salutation_id` as `sas_product_esd_order.orderLineItem.order.orderCustomer.salutationId`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`first_name` as `sas_product_esd_order.orderLineItem.order.orderCustomer.firstName`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`last_name` as `sas_product_esd_order.orderLineItem.order.orderCustomer.lastName`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`company` as `sas_product_esd_order.orderLineItem.order.orderCustomer.company`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`title` as `sas_product_esd_order.orderLineItem.order.orderCustomer.title`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`vat_ids` as `sas_product_esd_order.orderLineItem.order.orderCustomer.vatIds`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`customer_number` as `sas_product_esd_order.orderLineItem.order.orderCustomer.customerNumber`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`custom_fields` as `sas_product_esd_order.orderLineItem.order.orderCustomer.customFields`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`remote_address` as `sas_product_esd_order.orderLineItem.order.orderCustomer.remoteAddress`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`created_at` as `sas_product_esd_order.orderLineItem.order.orderCustomer.createdAt`, `sas_product_esd_order.orderLineItem.order.orderCustomer`.`updated_at` as `sas_product_esd_order.orderLineItem.order.orderCustomer.updatedAt`, `sas_product_esd_order.orderLineItem.order`.`item_rounding` as `sas_product_esd_order.orderLineItem.order.itemRounding`, `sas_product_esd_order.orderLineItem.order`.`total_rounding` as `sas_product_esd_order.orderLineItem.order.totalRounding`, `sas_product_esd_order.orderLineItem.order`.`created_at` as `sas_product_esd_order.orderLineItem.order.createdAt`, `sas_product_esd_order.orderLineItem.order`.`updated_at` as `sas_product_esd_order.orderLineItem.order.updatedAt`, `sas_product_esd_order.serial`.`id` as `sas_product_esd_order.serial.id`, `sas_product_esd_order.serial`.`esd_id` as `sas_product_esd_order.serial.esdId`, `sas_product_esd_order.serial`.`serial` as `sas_product_esd_order.serial.serial`, `sas_product_esd_order.serial`.`created_at` as `sas_product_esd_order.serial.createdAt`, `sas_product_esd_order.serial`.`updated_at` as `sas_product_esd_order.serial.updatedAt` FROM `sas_product_esd_order` LEFT JOIN `order_line_item` `sas_product_esd_order.orderLineItem` ON `sas_product_esd_order`.`order_line_item_id` = `sas_product_esd_order.orderLineItem`.`id` AND `sas_product_esd_order.orderLineItem`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN `sas_product_esd_serial` `sas_product_esd_order.serial` ON `sas_product_esd_order`.`serial_id` = `sas_product_esd_order.serial`.`id` LEFT JOIN `order` `sas_product_esd_order.orderLineItem.order` ON `sas_product_esd_order.orderLineItem`.`order_id` = `sas_product_esd_order.orderLineItem.order`.`id` AND `sas_product_esd_order.orderLineItem`.`order_version_id` = `sas_product_esd_order.orderLineItem.order`.`version_id` LEFT JOIN `order_customer` `sas_product_esd_order.orderLineItem.order.orderCustomer` ON `sas_product_esd_order.orderLineItem.order`.`id` = `sas_product_esd_order.orderLineItem.order.orderCustomer`.`order_id` AND `sas_product_esd_order.orderLineItem.order`.`version_id` = `sas_product_esd_order.orderLineItem.order.orderCustomer`.`order_version_id` WHERE (NOT (`sas_product_esd_order`.`order_line_item_id` <=> ? OR `sas_product_esd_order`.`serial_id` <=> ?))
Parameters: 
[
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(11.15%) 		1 
SELECT admin FROM `user` WHERE id = ?
Parameters: 
[
  b"\x01œáÿóÊxFšùE\x1Fé™ë³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(8.64%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(7.90%) 		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
0.38 ms
(7.64%) 		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\x06:dÌqD³L»fƨA"
  b"\x01\x06Fc%sª¶³\x1E¬8\t-"
  b"""
    \x01\n
    nÈ­sӁ¬þÎpÁÝX
    """
  b"\x01\e9\x12/q†ƒ·Çý’ïvÏ"
  b"\x01\x1F\x03Ž&q\x19¼†]ß`Ñ¥8"
  b"\x01)Ž!ªpÞ´a\fD¹v»š"
  b"\x01*_'\x1Dq€‹vÒ?\f7.Õ"
  b"\x01/ˆº\x0FpŸ‡\x04^ƒ_{\eb"
  b"\x01=Øõ\s\x16—ô\x1A\x11¤·â:"
  b"\x01=þs¹sò»\x01ó¿\x19\x01Ê\t"
  b"\x01>\x08‹Psô½5û\x01\x17'¼A"
  b"\x01CÙ.ýr”Ì\x15H+a³ä"
  b"\x01Ekh\x1Es¸± G\x02\rGu4"
  b"\x01YPT0r\x7F»IYþ‹‰á²"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(7.58%) 		1 
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = ?
Parameters: 
[
  b"\x01œáÿóÊxFšùE\x1Fé™ë³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(6.48%) 		1 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(5.22%) 		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.24 ms
(4.99%) 		1 
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`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(3.67%) 		1 
SELECT id FROM `pickware_erp_return_order_line_item` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(3.59%) 		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.12 ms
(2.53%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(2.40%) 		1 
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters: 
[
  b"\x01œáÿóÊxFšùE\x1Fé™ë³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(2.32%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(2.24%) 		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.08 ms
(1.59%) 		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.07 ms
(1.37%) 		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.06 ms
(1.24%) 		1 
SELECT shipping_costs FROM `pickware_erp_return_order` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.05 ms
(1.02%) 		1 
SELECT id FROM `order_return` LIMIT 1
Parameters: 
[]
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.