Error 400 Bad Request

POST https://www.all4team.de/api/product?_response=detail

Query Metrics

113 Database Queries
30 Different statements
36.60 ms Query time

Grouped Statements

Show all queries

Time Count Info
10.06 ms
(27.49%)
38
SELECT 1 as `exists` FROM `property_group_option_translation` WHERE (`property_group_option_id` = ?) AND (`language_id` = ?)
Parameters:
[
  b"\x01‰cåõ;r’°\x03¿h\x03ö$·"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
8.79 ms
(24.02%)
32
SELECT 1 as `exists` FROM `property_group_translation` WHERE (`property_group_id` = ?) AND (`language_id` = ?)
Parameters:
[
  b"\x01诰¾$p█àVCÀlpôØ"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
2.48 ms
(6.79%)
8
SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = ?) AND (`version_id` = ?)
Parameters:
[
  b"\x01ØÌþ┼\x15s@ò└¥.ÍG9-"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
2.25 ms
(6.15%)
8
SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)
Parameters:
[
  b"\x01ØÌþ┼\x15s@ò└¥.ÍG9-"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
2.01 ms
(5.49%)
1
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
1.01 ms
(2.76%)
1
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`.`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`.`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`.`name` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "SwagCustomNotification"
]
0.79 ms
(2.17%)
1
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
  b"É\x1Eòײ·Iû¹í—,Õ\x13\x7FË"
]
0.75 ms
(2.06%)
1
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
0.63 ms
(1.73%)
1
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters:
[]
0.61 ms
(1.67%)
2
SELECT 1 as `exists` FROM `product_configurator_setting` WHERE (`id` = ?) AND (`version_id` = ?)
Parameters:
[
  b"\x01ØÌþ┼\x16q‗│{ú\t\x08Ç·*"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
0.59 ms
(1.60%)
1
SELECT 1 as `exists`, `product_id`, `language_id`, `product_version_id` FROM `product_translation` WHERE (`product_id`,`language_id`,`product_version_id`) IN ((?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?),(?,?,?))
Parameters:
[
  b"\x01ØÌþ┼\x15s@ò└¥.ÍG9-"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x16q‗│{ú\t\t\x1F"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x17p╠½¼¼V°ªä+"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x17p╠½¼¼V¨;º5"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x17p╠½¼¼V¨█Ðp"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x17p╠½¼¼V·vÌ▄"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x18qË¥Óƒ<Ø|eF"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ØÌþ┼\x18qË¥Óƒ<Ø£_d"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
0.52 ms
(1.43%)
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:
[]
0.51 ms
(1.39%)
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:
[]
0.44 ms
(1.21%)
1
SELECT 1 as `exists`, `property_group_option_id`, `language_id` FROM `property_group_option_translation` WHERE (`property_group_option_id`,`language_id`) IN ((?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?),(?,?))
Parameters:
[
  b"\x01‰cåõ;r’°\x03¿h\x03ö$·"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰cê$ÁrQš\x11\x17nW\vÊä"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰d\x11ã\x00r’»ò‘©ƒzŒÈ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰d\x12µüq‘´\x12îgÚ\x02\ek"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"c£äã¨ÐF\x1C©7"vGËÄt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"h\x18I\v=&Jó–¿2µÇAË\x18"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x10<"\x1EõÅG¦‘•HrjE­·"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ºÎUÅ\tbMЏ Äe;ÎÔw"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"±└Î\føqLL▓{ÙÅ"'2B"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"=\v\x11ÑÛ\x0FH÷¬²„—m\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.44 ms
(1.19%)
1
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
0.43 ms
(1.16%)
1
SELECT item_rounding FROM currency WHERE id = ?
Parameters:
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.39 ms
(1.08%)
1
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "en-GB"
]
0.37 ms
(1.02%)
1
SELECT 1 as `exists`, parent_id, `id`, `version_id` FROM `product` WHERE (`id` IN (?,?,?,?,?,?,?,?)) AND (version_id = ?)
Parameters:
[
  b"\x01ØÌþ┼\x16q‗│{ú\t\t\x1F"
  b"\x01ØÌþ┼\x17p╠½¼¼V°ªä+"
  b"\x01ØÌþ┼\x17p╠½¼¼V¨;º5"
  b"\x01ØÌþ┼\x17p╠½¼¼V¨█Ðp"
  b"\x01ØÌþ┼\x17p╠½¼¼V·vÌ▄"
  b"\x01ØÌþ┼\x18qË¥Óƒ<Ø|eF"
  b"\x01ØÌþ┼\x18qË¥Óƒ<Ø£_d"
  b"\x01ØÌþ┼\x15s@ò└¥.ÍG9-"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
0.37 ms
(1.00%)
1
SELECT 1 as `exists`, `id` FROM `property_group_option` WHERE `id` IN (?,?,?,?,?,?,?,?,?,?)
Parameters:
[
  b"\x01‰cåõ;r’°\x03¿h\x03ö$·"
  b"\x01‰cê$ÁrQš\x11\x17nW\vÊä"
  b"\x01‰d\x11ã\x00r’»ò‘©ƒzŒÈ"
  b"\x01‰d\x12µüq‘´\x12îgÚ\x02\ek"
  b"c£äã¨ÐF\x1C©7"vGËÄt"
  b"h\x18I\v=&Jó–¿2µÇAË\x18"
  b"\x10<"\x1EõÅG¦‘•HrjE­·"
  b"ºÎUÅ\tbMЏ Äe;ÎÔw"
  b"±└Î\føqLL▓{ÙÅ"'2B"
  b"=\v\x11ÑÛ\x0FH÷¬²„—m\v"
]
0.36 ms
(0.99%)
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"Ru#?•ðIšœ)=sµŽ\eÂ"
]
0.36 ms
(0.98%)
1
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters:
[]
0.33 ms
(0.91%)
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"Ru#?•ðIšœ)=sµŽ\eÂ"
]
0.31 ms
(0.85%)
1
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
0.31 ms
(0.84%)
1
SELECT 1 as `exists`, `id` FROM `product_visibility` WHERE `id` IN (?,?)
Parameters:
[
  b"\x01ØÌþ┼\x15s@ò└¥.Î\rÓÿ"
  b"\x01ØÌþ┼\x15s@ò└¥.ÎâÎ="
]
0.30 ms
(0.83%)
1
SELECT 1 as `exists`, `property_group_id`, `language_id` FROM `property_group_translation` WHERE (`property_group_id`,`language_id`) IN ((?,?),(?,?),(?,?),(?,?))
Parameters:
[
  b"\x01诰¾$p█àVCÀlpôØ"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01èÚÊÅñqù×R\x04SÿC\x03°"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‰cåéÃr®„IYÁ~P\x07½"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Šîù\eÞqè¾\x1FAgâÞš†"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.26 ms
(0.72%)
1
SELECT id FROM integration WHERE access_key = ?
Parameters:
[
  "SWIABJLLUHDXAFVVREDNBEDDZG"
]
0.24 ms
(0.67%)
1
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
  b"É\x1Eòײ·Iû¹í—,Õ\x13\x7FË"
]
0.24 ms
(0.66%)
1
SELECT 1 as `exists`, `id`, `version_id` FROM `product_configurator_setting` WHERE (`id` IN (?,?)) AND (version_id = ?)
Parameters:
[
  b"\x01ØÌþ┼\x16q‗│{ú\t\x08Ç·*"
  b"\x01ØÌþ┼\x16q‗│{ú\t\x08ðüÁ"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
0.22 ms
(0.59%)
1
SELECT admin FROM `integration` WHERE id = ?
Parameters:
[
  b"Ru#?•ðIšœ)=sµŽ\eÂ"
]
0.21 ms
(0.57%)
1
SELECT 1 as `exists`, `id` FROM `property_group` WHERE `id` IN (?,?,?,?)
Parameters:
[
  b"\x01诰¾$p█àVCÀlpôØ"
  b"\x01èÚÊÅñqù×R\x04SÿC\x03°"
  b"\x01‰cåéÃr®„IYÁ~P\x07½"
  b"\x01Šîù\eÞqè¾\x1FAgâÞš†"
]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.