Deprecated: Implicit conversion from float 1747170840.936527 to int loses precision in /var/www/share/demo.shopware.agiqon.de/htdocs/custom/plugins/FroshProfiler/Components/Struct/Profile.php on line 193

Deprecated: Return type of Zend_Db_Statement_Pdo::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/share/demo.shopware.agiqon.de/htdocs/engine/Library/Zend/Db/Statement/Pdo.php on line 254
Shopware Profiler

https://demo.shopware.agiqon.de/api/pickware/users

Method
GET
HTTP Status
200
IP
93.241.60.106
Profiled on
2025-05-13 09:42:24
Token
6822f7e035571

Queries

51 Total Queries
0.0194 s Total Query Time
SQL Params Execution Time 
SELECT 
  name, 
  id, 
  name, 
  label, 
  description, 
  source, 
  active, 
  installation_date as installationDate, 
  update_date as updateDate, 
  version 
FROM 
  s_core_plugins 
WHERE 
  namespace =: namespace 
  AND name not IN(: names)
 
array:2 [
  "namespace" => "Core"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0019 ms 
SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = : namespace 
WHERE 
  ce.type = 0 
  AND cp.name NOT IN(: names) 
ORDER BY 
  name, 
  position
 
array:2 [
  "namespace" => "Core"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0051 ms 
SELECT 
  name, 
  id, 
  name, 
  label, 
  description, 
  source, 
  active, 
  installation_date as installationDate, 
  update_date as updateDate, 
  version 
FROM 
  s_core_plugins 
WHERE 
  namespace =: namespace 
  AND name not IN(: names)
 
array:2 [
  "namespace" => "Frontend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0006 ms 
SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = : namespace 
WHERE 
  ce.type = 0 
  AND cp.name NOT IN(: names) 
ORDER BY 
  name, 
  position
 
array:2 [
  "namespace" => "Frontend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0008 ms 
SELECT 
  name, 
  id, 
  name, 
  label, 
  description, 
  source, 
  active, 
  installation_date as installationDate, 
  update_date as updateDate, 
  version 
FROM 
  s_core_plugins 
WHERE 
  namespace =: namespace 
  AND name not IN(: names)
 
array:2 [
  "namespace" => "Backend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0003 ms 
SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = : namespace 
WHERE 
  ce.type = 0 
  AND cp.name NOT IN(: names) 
ORDER BY 
  name, 
  position
 
array:2 [
  "namespace" => "Backend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0008 ms 
SELECT 
  name, 
  version, 
  active, 
  installation_date AS installed 
FROM 
  s_core_plugins
 
[]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.column_name = ? 
LIMIT 
  1
 
array:1 [
  0 => "viisonMoss"
]
0.0013 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.column_name = ? 
LIMIT 
  1
 
array:1 [
  0 => "viisonOtherServiceParagraphOneOrTwo"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.table_name = ? 
  AND t0.column_name = ? 
LIMIT 
  1
 
array:2 [
  0 => "s_core_paymentmeans_attributes"
  1 => "viison_datev_debtor_account"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.table_name = ? 
  AND t0.column_name = ? 
LIMIT 
  1
 
array:2 [
  0 => "s_core_paymentmeans_attributes"
  1 => "viison_datev_clearing_account"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.table_name = ? 
  AND t0.column_name = ? 
LIMIT 
  1
 
array:2 [
  0 => "s_core_paymentmeans_attributes"
  1 => "viison_datev_period_of_payment"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.table_name = ? 
  AND t0.column_name = ? 
LIMIT 
  1
 
array:2 [
  0 => "s_user_attributes"
  1 => "viison_datev_company_code"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.table_name = ? 
  AND t0.column_name = ? 
LIMIT 
  1
 
array:2 [
  0 => "s_user_attributes"
  1 => "viison_datev_debtor_account"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.id = ? 
LIMIT 
  1
 
array:1 [
  0 => 65
]
0.0002 ms 
SELECT 
  * 
FROM 
  `s_core_plugins`
 
[]
0.0010 ms 
SELECT 
  t0.id AS id_1, 
  t0.locale AS locale_2, 
  t0.language AS language_3, 
  t0.territory AS territory_4 
FROM 
  s_core_locales t0 
WHERE 
  t0.locale = ? 
LIMIT 
  1
 
array:1 [
  0 => "en_GB"
]
0.0002 ms 
SET 
  @b2b_request_uuid = : uuid;
 
array:1 [
  "uuid" => "nK2zTaIQut30MKAtkp3tgUHyZIpXHyKk5FRPEk4P"
]
0.0001 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName3099714110
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName3099714110" => "SwagSecurity"
  "shopId2212294583" => 1
]
0.0085 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName3099714110
 
array:1 [
  "pluginName3099714110" => "SwagSecurity"
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName3425890772
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName3425890772" => "InputFilter"
  "shopId2212294583" => 1
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName3425890772
 
array:1 [
  "pluginName3425890772" => "InputFilter"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0
 
[]
0.0008 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.column_name = ? 
LIMIT 
  1
 
array:1 [
  0 => "viisonCountryOfOrigin"
]
0.0002 ms 
SELECT 
  t0.id AS id_1, 
  t0.table_name AS table_name_2, 
  t0.column_name AS column_name_3, 
  t0.column_type AS column_type_4, 
  t0.default_value AS default_value_5, 
  t0.entity AS entity_6, 
  t0.label AS label_7, 
  t0.readonly AS readonly_8, 
  t0.help_text AS help_text_9, 
  t0.support_text AS support_text_10, 
  t0.translatable AS translatable_11, 
  t0.display_in_backend AS display_in_backend_12, 
  t0.custom AS custom_13, 
  t0.position AS position_14, 
  t0.array_store AS array_store_15 
FROM 
  s_attribute_configuration t0 
WHERE 
  t0.column_name = ? 
LIMIT 
  1
 
array:1 [
  0 => "viisonCustomsTariffNumber"
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName3343718869
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName3343718869" => "ViisonPickwareERP"
  "shopId2212294583" => 1
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName3343718869
 
array:1 [
  "pluginName3343718869" => "ViisonPickwareERP"
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName3150267880
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName3150267880" => "ViisonPickwarePOS"
  "shopId2212294583" => 1
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName3150267880
 
array:1 [
  "pluginName3150267880" => "ViisonPickwarePOS"
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName3899353074
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName3899353074" => "sKUZOOffer"
  "shopId2212294583" => 1
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName3899353074
 
array:1 [
  "pluginName3899353074" => "sKUZOOffer"
]
0.0002 ms 
"START TRANSACTION"
 
null
0.0001 ms 
INSERT INTO pickware_erp_rest_api_requests (
  date, method, url, requestHeaders, 
  requestData, responseCode, responseHeaders, 
  responseData, exception, user, ipAddress, 
  userAgent, computationTime, idempotentOperationId
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
 
array:14 [
  1 => DateTime @1747122144 {#4888
    date: 2025-05-13 09:42:24.185620 Europe/Berlin (+02:00)
  }
  2 => "GET"
  3 => "https://demo.shopware.agiqon.de/api/pickware/users"
  4 => """
    host: demo.shopware.agiqon.de\n
    pickware-device-uuid: 7E115C3D-E6B7-469D-9547-92484D002987\n
    accept-language: de-DE;q=1\n
    user-agent: Stocking/5.8.6 (iPod touch; iOS 15.8; Scale/2.00)\n
    pickware-api-version: 2020-10-01\n
    accept-encoding: gzip, deflate, br\n
    accept: */*\n
    authorization: <HIDDEN FIELD>\n
    forwarded: for="93.241.60.106";host="demo.shopware.agiqon.de";proto=https\n
    x-forwarded-for: 93.241.60.106\n
    surrogate-capability: shopware="ESI/1.0", symfony="ESI/1.0"
    """
  5 => null
  6 => null
  7 => null
  8 => null
  9 => null
  10 => null
  11 => "93.241.60.106"
  12 => "Stocking/5.8.6 (iPod touch; iOS 15.8; Scale/2.00)"
  13 => null
  14 => null
]
0.0030 ms 
"COMMIT"
 
null
0.0016 ms 
SELECT 
  t0.id AS id_1, 
  t0.uuid AS uuid_2, 
  t0.name AS name_3, 
  t0.appName AS appName_4, 
  t0.confirmed AS confirmed_5, 
  t0.added AS added_6, 
  t0.lastLogin AS lastLogin_7 
FROM 
  pickware_rest_api_devices t0 
WHERE 
  t0.uuid = ? 
  AND t0.appName = ? 
LIMIT 
  1
 
array:2 [
  0 => "7E115C3D-E6B7-469D-9547-92484D002987"
  1 => "Stocking"
]
0.0030 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName2040627552
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName2040627552" => "almArticleBadges"
  "shopId2212294583" => 1
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName2040627552
 
array:1 [
  "pluginName2040627552" => "almArticleBadges"
]
0.0002 ms 
"START TRANSACTION"
 
null
0.0001 ms 
UPDATE 
  pickware_erp_rest_api_requests 
SET 
  responseCode = ?, 
  responseHeaders = ?, 
  responseData = ?, 
  computationTime = ? 
WHERE 
  id = ?
 
array:5 [
  0 => 200
  1 => """
    cache-control: no-cache, private\n
    Cache-Control: no-cache, private\n
    date: Tue, 13 May 2025 07:42:24 GMT\n
    Date: Tue, 13 May 2025 07:42:24 GMT\n
    content-type: application/json\n
    Content-Type: application/json
    """
  2 => "{"success":true,"data":[{"id":51,"username":"aq_admin","name":"AQ Admin"},{"id":52,"username":"agq_admin","name":"test"}]}"
  3 => 0.020504951477051
  4 => 4117
]
0.0002 ms 
"COMMIT"
 
null
0.0009 ms 
SELECT 
  @@SESSION.collation_connection;
 
[]
0.0001 ms 
"START TRANSACTION"
 
null
0.0001 ms 
SELECT 
  * 
FROM 
  b2b_s_order_change_queue 
WHERE 
  request_uuid = @b2b_request_uuid COLLATE utf8mb4_general_ci 
GROUP BY 
  s_order_id;
 
[]
0.0009 ms 
DELETE FROM 
  b2b_s_order_change_queue 
WHERE 
  request_uuid = @b2b_request_uuid COLLATE utf8mb4_general_ci
 
null
0.0001 ms 
"COMMIT"
 
null
0.0000 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName288793961
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
 
array:2 [
  "pluginName288793961" => "PasswordEncoder"
  "shopId2212294583" => 1
]
0.0002 ms 
SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName288793961
 
array:1 [
  "pluginName288793961" => "PasswordEncoder"
]
0.0002 ms 
SELECT 
  `locale`.`locale` 
FROM 
  `s_core_shops` AS `shop` 
  LEFT JOIN `s_core_locales` AS `locale` ON `locale`.`id` = `shop`.`locale_id` 
WHERE 
  `shop`.`default` = 1
 
[]
9.5959 ms 
SELECT 
  name 
FROM 
  s_core_documents dt 
  INNER JOIN s_plugin_viison_coupon_coupon_document_types cdt ON cdt.documentTypeId = dt.id
 
[]
2.0700 ms 
SELECT 
  `s_core_auth`.* 
FROM 
  `s_core_auth` 
WHERE 
  (username LIKE '')
 
[]
6.0301 ms 
SELECT 
  a.id, 
  a.username, 
  a.name 
FROM 
  s_core_auth a 
  LEFT JOIN s_core_auth_attributes aa ON a.id = aa.authID 
WHERE 
  a.active = 1 
  AND aa.viison_pickware_pin IS NOT NULL
 
[]
1.7061 ms