https://sw5.netzhirsch.de/api/config.env

Queries

13 Total Queries
0.0000 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.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" => "Core"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0006 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.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" => "Frontend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0005 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.0005 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.0003 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 
  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 = : pluginName2585463947
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )
array:2 [
  "pluginName2585463947" => "AtsdCustomerOrigin"
  "shopId2212294583" => 1
]
0.0003 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 = : pluginName2585463947
array:1 [
  "pluginName2585463947" => "AtsdCustomerOrigin"
]
0.0002 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
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.0004 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.0003 ms